Explore data areas with SQL

Last Updated on 22 March 2020 by Roberto De Pedrini MarkOne’s suggestions – n. 6 In the large list of functions and views of the DB2 for i Service family, there are some that allow you to manage data area objects (* DTAARA) through SQL statements. Index Toggle List the data areas To obtain a list of the data areas present in a library, you can use the OBJECT_STATISTIC S table function : select OBJNAME "Name", OBJTEXT "Description", OBJOWNER "Owner", timestamp (OBJCREATED, 0) "Creation date / time", timestamp (CHANGE_TIMESTAMP, 0) "Date / time last mod.", timestamp (LAST_USED_TIMESTAMP, 0 ) "Last use date / time", DAYS_USED_COUNT "Use day" from table (QSYS2 / OBJECT_STATISTICS ('QUSRSYS', '* …