SQL Archive

Non-Shared Temp Tables Cleanup

Some of the processes that depend on shared table instances , can experience a dramatic differences in performance, in case all of the instances available are being used, or remaining locked by some orphan

DB2 Scripts – Table Management

Here are a few more nice DB2 scripts that would save you time: Get all tables in Table Space -- Get all tables in particular tablespaceselect SUBSTR(TABNAME,1,25) "TABNAME", SUBSTR(TABSCHEMA,1,15) "SCHEMA", NPAGES, CARD from syscat.tables