Shareholders may cast their votes electronically for certain General Meetings of all companies. SQL for Tivoli Storage Manager. SQL for Tivoli Storage Manager. Useful SQL Statements for TSM 0. This page has a collection of useful SQL statements for IBM Tivoli Storage Manager TSM. Here you can find out a lot of selects that will help you to get information from TSM. SQL statements. If you have any selects to share or have any comments. Database and Recovery Log. Nodes. Filespaces. Occupancy. Schedules. Drives and Paths. Management class. Copy Groups. Activity Log. Archive Objects. Backup Objects. Summary. Volumes. Total Copy 1.2' title='Total Copy 1.2' />Storage Pools. Events. Volume History. DRMSessions. Backups. Processes. Other. Thank You. Free Download Total Copy 1. Shell extension designed to enable you to pause and resume file copy operations, while offering the possibility to li. Database and Recovery Log. List all information from db table. TSM version 5 and 6 the below output is from version 5. SERVER1 SELECT FROM db. AVAILSPACEMB 8. CAPACITYMB 8. MAXEXTENSIONMB 5. MAXREDUCTIONMB 1. PAGESIZE 4. 09. USABLEPAGES 2. USEDPAGES 1. 68. PCTUTILIZED 8. MAXPCTUTILIZED 8. PHYSICALVOLUMES 1. BUFFPOOLPAGES 6. TOTALBUFFERREQ 5. CACHEHITPCT 9. CACHEWAITPCT 0. BACKUPRUNNING NO. BACKUPTYPE. NUMBACKUPINCR 0. BACKUPCHGMB. BACKUPCHGPCT 1. LASTBACKUPDATE 2. DBREORGEST. DBREORGESTTIME. TSM database utilization. TSM version 6. tsm SERVER1 SELECT CASTSUM1. AS DECIMAL3,1 AS PCTUTILIZED FROM db. TSM version 5. tsm SERVER1 SELECT pctutilized FROM db. TSM log recovery utilization. TSM version 6 active log. SERVER1 SELECT CASTSUMusedspacemb. MB AS DECIMAL3,1 AS PCTUTILIZED FROM log. TSM version 6 active log. SERVER1 SELECT CASTSUM1. AS DECIMAL3,1 AS PCTUTILIZED FROM log. TSM version 5. tsm SERVER1 SELECT pctutilized FROM log. Selecting specific columns from db table. TSM version 6. tsm SERVER1 SELECT totfilesystemmb, useddbspacemb, freespacemb,. SELECT CASTSUM1. AS DECIMAL3,1 AS PCTUTILIZED FROM db,. FROM db. TOTFILESYSTEMMB USEDDBSPACEMB FREESPACEMB PCTUTILIZED LASTBACKUPDATE. TSM version 5. tsm SERVER1 SELECT availspacemb,capacitymb, pctutilized, maxpctutilized,lastbackupdate FROM db. AVAILSPACEMB CAPACITYMB PCTUTILIZED MAXPCTUTILIZED LASTBACKUPDATE. Number of database volumes not synchronized. TSM version 5 only. SERVER1 SELECT COUNT FROM dbvolumes WHERE NOT copy. Synchronized OR NOT. Synchronized OR NOT copy. Synchronized. Number of log volumes not synchronized. TSM version 5 only. SERVER1 SELECT COUNT FROM logvolumes WHERE NOT copy. Synchronized OR NOT. Synchronized OR NOT copy. Synchronized. Nodes. Number of nodes. TSM version 5 and 6. SERVER1 SELECT SUMnumnodes FROM domains. TSM version 5 and 6. SERVER1 SELECT COUNT FROM nodes. Number of nodes per domain. TSM version 5 and 6. SERVER1 SELECT domainname,numnodes FROM domains. DOMAINNAME NUMNODES. AIX 4. EXCHANGE 4. NT 6. VMWARE 1. Number of nodes per platform. TSM version 5 and 6. SERVER1 SELECT platformname,COUNT FROM nodes GROUP BY platformname. PLATFORMNAME Unnamed2. AIX 2. Linux. 86 3. TDP Domino 2. TDP MSSQL Win. Win. NT 1. TSM version 5 and 6. SERVER1 SELECT nodename FROM nodes WHERE lockedYES. Number of nodes locked. TSM version 5 and 6. SERVER1 SELECT COUNT FROM nodes WHERE lockedYES. Number of nodes sessions. TSM version 5 and 6. SERVER1 SELECT COUNT FROM sessions WHERE sessiontypeNode. TSM clients version. TSM version 6. tsm SERVER1 SELECT nodename, platformname, domainname, TRIMCHARclientversion. TRIMCHARclientrelease. TRIMCHARclientlevel TRIMCHARclientsublevel as TSM Client Version, DATElastacctime AS LASTACCTIME FROM nodes. TSM version 5. tsm SERVER1 SELECT nodename, platformname, domainname, VARCHARclientversion. VARCHARclientrelease. VARCHARclientlevel VARCHARclientsublevel as TSM Client Version, DATElastacctime AS LASTACCTIME FROM nodes. NODENAME PLATFORMNAME DOMAINNAME TSM Client Version LASTACCTIME. NODE0. 1 Win. NT STANDARD 6. NODE0. 2 AIX STANDARD 6. NODE0. 3 TDP Domino AIX STANDARD 5. NODE0. 4 TDP Dom LINUXZ6. STANDARD 6. 1. NODE0. Linux. STANDARD 6. NODE0. 6 TDP Domino AIX STANDARD 5. NODE0. 7 AIX STANDARD 5. NODE0. 8 AIX STANDARD 5. Number of nodes per TSM client version. TSM version 6 only. SERVER1 SELECT TRIMCHARclientversion. TRIMCHARclientrelease. TRIMCHARclientlevel TRIMCHARclientsublevel. TSMClientVersion, count as numbernodes FROM nodes GROUP BY. TRIMCHARclientversion. TRIMCHARclientrelease. TRIMCHARclientlevel TRIMCHARclientsublevel. TSMCLIENTVERSION NUMBERNODES. List of nodes that have not accessed the tsm server in the last 9. TSM version 6. tsm SERVER1 SELECT nodename, domainname, platformname, TOCHARlastacctime,YYYY MM DD HH2. MI as lastacctime FROM. WHERE DAYScurrentdate DAYSlastacctime 9. ORDER BY lastacctime. TSM version 5. tsm SERVER1 SELECT nodename, domainname, platformname, SUBSTRCHARlastacctime,1,1. FROM nodes WHERE. ORDER BY lastacctime. NODENAME DOMAINNAME PLATFORMNAME lastacctime. NODE1. 23 PROD AIX 2. NODE2. 34 PROD Win. NT 2. 01. 1 0. NODE3. The King Of Fighters 2006 Free Download Pc. PROD DB2AIX6. Some nodes information and amount of space from auditocc. TSM version 5 and 6. SERVER1 SELECT n. TRIMCHARclientversion. TRIMCHARclientrelease. TRIMCHARclientlevel TRIMCHARclientsublevel as TSMClientVersion,. DEC8,2 AS TOTALGB, DATEn. LASTACCDATE FROM nodes n, auditocc a WHERE n. ORDER BY TOTALGB DESC. NODENAME DOMAINNAME PLATFORMNAME TSMCLIENTVERSION TOTALGB LASTACCDATE. NODE1 OFFSITE AIX 6. NODE2 OFFSITE AIX 6. NODE3 SERVERS DB2AIX6. NODE4 OFFSITE AIX 6. NODE5 SERVERS Linux. Filespaces. List filespaces that have not been backed up in the last 3. TSM version 5 and 6. SERVER1 SELECT nodename,filespacename, filespacetype,DATEbackupend as DATE FROM filespaces WHERE. DAYScurrentdate DAYSbackupend 3. TSM version 5. tsm SERVER1 SELECT nodename,filespacename, filespacetype,DATEbackupend as DATE FROM filespaces WHERE. DAYS. NODENAME FILESPACENAME FILESPACETYPE DATE. NODE1. 32 db. EXT3 2. NODE1. 32 db. EXT3 2. NODE1. 32 dbwork EXT3 2. NODE1. 32 home EXT3 2. Occupancy. Number of files per client. TSM version 5 and 6. SERVER1 SELECT nodename, SUMnumfiles FROM occupancy GROUP BY nodename. NODENAME Unnamed2. NODE0. 1 2. NODE0. NODE0. 3 1. NODE0. Space and number of files stored per client. TSM version 5 and 6. SERVER1 SELECT nodename,CASTFLOATSUMphysicalmb 1. AS DEC8,2as Space in GB,. SUMnumfilesasNumber of files FROM occupancy GROUP BY nodename. NODENAME Space in GB Number of files. SERVER 0. 1 1. SERVER 0. SERVER 0. 3 3. SERVER 0. Data stored per client GB. TSM version 5 and 6.