tag:blogger.com,1999:blog-8511582004628294092.post8768170952389636576..comments2023-10-15T08:41:04.989-05:00Comments on System i (iSeries) Management Tips: 4/28/08 How to determine what is eating up your disk spaceVision Solutionshttp://www.blogger.com/profile/16215584555802905635noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8511582004628294092.post-5984078575227280922009-03-26T04:59:00.000-05:002009-03-26T04:59:00.000-05:00Your SQL should be: SELECT ODOBNM, ODLBNM, ODOBTP,...Your SQL should be: <BR/><BR/>SELECT ODOBNM, ODLBNM, ODOBTP, (ODSIZU * ODBPUN) <BR/>FROM QGPL/OBJLIST <BR/>ORDER BY (ODSIZU * ODBPUN) DESC <BR/><BR/>Otherwise you might miss really big objects that exceed the size of a 4 byte integer. <BR/><BR/>ODSIZU is the object size in units and ODBPUN is the unit size.Unknownhttps://www.blogger.com/profile/11178857481885490512noreply@blogger.com