Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Home / StoredProcedures / DBAdmin-Tools / find_tmp_tbls / Personal / Informix Tools
Name Modified Size InfoDownloads / Week
Parent folder
find_temp_tables.ksh 2019-06-13 13.8 kB
0
README.find_temp_tables.txt 2019-06-13 1.1 kB
0
Totals: 2 Items   14.9 kB 0 
 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 <filename> -- 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
 make it run.
Source: README.find_temp_tables.txt, updated 2019-06-13