Shell Script to print which Temp Tables belong to which session Inputs: Argument 1 -- -b[rief] -- To print the name of Temp Tables and num rows -- -d[etail] -- To print the name, columns and num rows of each temp table Argument 2 -- -f -- To log the output, default is screen (optional) Version 1.2 -- Prints the correct nrows and npused for the temp table. Version 1.3 -- Made the script compatible to Linux OS as well. Version 1.4 -- Takes care of nrows/npused for Fragmented tables Version 1.5 -- Prints out the DBSPACE and DATABASE information for TEMP TABLES as well Versions Tested Against: ------------------------ 7.31.UD1, 7.31.UD2, 7.31.UC6, 9.21.UC4, 9.21.FC4, 9.30.FC2 Platforms Tested: ----------------- Sun Solaris (2.6, 2.7) HP-UX (10.20 & 11.0) Linux R/H 6.2 Kernel 2.2.19 Caveat ------- If you are going to run the script on any other platform, in the script there is a hard coded value for osname for some utilities which required in order to