?

Log in

No account? Create an account

Josh-D. S. Davis

Xaminmo / Omnimax / Max Omni / Mad Scientist / Midnight Shadow / Radiation Master

Previous Entry Share Next Entry
TSM 5.5 to 6.2.3 upgrade in the lab...
Josh 201604 KWP
joshdavis
After upgrading XP to 2008 R2 (manual process) and spending way too much time on Facebook, and troubleshooting the problems if bringing up a 5.5 32-bit instance on a 64-bit OS rather than install/restore, I was finally ready... Total time was 22 minutes (small database, single SATA drive).


C:\Program Files\Tivoli\TSM\server1>"\Program Files (x86)\Tivoli\tsm\upgrade\dsmupgrd.exe" extractdb hladdress=127.0.0.1 lladdress=1500
ANR0900I Processing options file C:\Program Files\Tivoli\TSM\server1\dsmserv.opt.
ANR7800I DSMSERV generated at 10:33:00 on Oct 24 2011.

Tivoli Storage Manager for Windows
Version 5, Release 5, Level 6.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2009.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0200I Recovery log assigned capacity is 8192 megabytes.
ANR0201I Database assigned capacity is 4096 megabytes.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR1635I The server machine GUID, ---REDACTED---, has initialized.
ANR4726I The NAS-NDMP support module has been loaded.
ANR1811W HBAAPI returned zero FC adapters from the system.
ANR4029I EXTRACTDB: Database checkpoint started.
ANR4030I EXTRACTDB: Database checkpoint completed.
ANR0610I EXTRACTDB started by ADMINISTRATOR as process 1.
ANR0408I Session 1 started for server $UPGRADETARGET$ (Windows) (Tcp/Ip) for V6 Database Upgrade.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE5.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE3.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE4.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE1.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE2.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE0.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE6.DSM varied online.
ANR1305I Disk volume E:\TIVOLI\TSM\SERVER1\DISKE7.DSM varied online.
ANR1392I EXTRACTDB: Extracted 5,681,696 database entries in 281,929 pages and wrote 705,925,463 bytes in 0:05:01 (8049.17 megabytes per hour).
ANR0409I Session 1 ended for server $UPGRADETARGET$ (Windows).
ANR1382I EXTRACTDB: Process 1, database extract, has completed.
ANR1383I EXTRACTDB: Found 120 database objects.
ANR1384I EXTRACTDB: Processed 74 database objects.
ANR1385I EXTRACTDB: Skipped 46 empty database objects.
ANR1386I EXTRACTDB: Failed to process 0 database objects.
ANR1387I EXTRACTDB: Processed 9,537,486 database records.
ANR1388I EXTRACTDB: Read 465,154 database pages.
ANR1389I EXTRACTDB: Wrote 1,107,047,545 bytes.
ANR1390I EXTRACTDB: Elapsed time was 0:09:31.
ANR1391I EXTRACTDB: Throughput was 6651.49 megabytes per hour.




C:\tivoli\tsm\server1>"c:\Program Files\Tivoli\TSM\server\dsmserv" insertdb sesswait=60
ANR7800I DSMSERV generated at 12:32:53 on Aug 2 2011.

Tivoli Storage Manager for Windows
Version 6, Release 2, Level 3.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2010.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR0900I Processing options file C:\tivoli\tsm\server1\dsmserv.opt.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR1380I The buffer pool monitor switch is enabled.
ANR1636W The server machine GUID changed: old value (), new value REDACTED.
ANR7808W Sun Microsystems Library Attach module libacs.dll is not available from the system.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
ANR1336I INSERTDB: Ready for connections from the source server. Remaining time: 1:00:00
ANR1336I INSERTDB: Ready for connections from the source server. Remaining time: 0:56:00
ANR0408I Session 1 started for server $UPGRADESOURCE$ (Windows) (Tcp/Ip) for V6 Database Upgrade.
ANR1337I A DBSPACE trigger has been removed.
ANR1337I A LOGSPACE trigger has been removed.
ANR1379I INSERTDB: Read 12,390,151 bytes and inserted 113,698 database entries in 0:00:00 (0.00 megabytes per hour).
ANR1379I INSERTDB: Read 735,258,312 bytes and inserted 5,900,686 database entries in 0:05:00 (8412.00 megabytes per hour).
ANR0409I Session 1 ended for server $UPGRADESOURCE$ (Windows).
ANR0478W Session request refused. Server is running in standalone mode.
ANR1379I INSERTDB: Read 1,107,047,615 bytes and inserted 9,537,486 database entries in 0:10:00 (6330.00 megabytes per hour).
ANR0336I Runstats for table STAGED_EXPIRING_OBJECTS started.
ANR0337I Runstats for table STAGED_EXPIRING_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table STAGED_OBJECT_IDS started.
ANR0337I Runstats for table STAGED_OBJECT_IDS ended with sqlCode 0.
ANR0336I Runstats for table ARCHIVE_OBJECTS started.
ANR0337I Runstats for table ARCHIVE_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table BACKUP_OBJECTS started.
ANR0337I Runstats for table BACKUP_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table SPACEMAN_OBJECTS started.
ANR0337I Runstats for table SPACEMAN_OBJECTS ended with sqlCode 0.ANR0136I Table updating statistics performed successfully for 5 of 5.
ANR1524I INSERTDB: Beginning database update phase.
ANR1525I INSERTDB: Updated 35 of 2,522,440 database entries in 0:02:46.
ANR1525I INSERTDB: Updated 2,522,440 of 2,522,440 database entries in 0:02:56.
ANR1395I INSERTDB: Process 1, database insert, has completed.
ANR1397I INSERTDB: Found 74 database objects.
ANR1398I INSERTDB: Processed 74 database objects.
ANR1399I INSERTDB: Failed to process 0 database objects.
ANR1517I INSERTDB: Processed 9,537,486 database records.
ANR1518I INSERTDB: Read 1,107,047,615 bytes.
ANR1519I INSERTDB: Elapsed time was 0:15:32.
ANR1445I INSERTDB: Throughput was 4075.11 megabytes per hour.
ANR1446I RUNSTATS: Table updating statistics started.
ANR0336I Runstats for table ADMIN_EMAILS started.
ANR0337I Runstats for table ADMIN_EMAILS ended with sqlCode 0.
ANR0336I Runstats for table ACTIVITY_LOG started.
ANR0337I Runstats for table ACTIVITY_LOG ended with sqlCode 0.
ANR0336I Runstats for table ADMINISTRATORS started.
ANR0337I Runstats for table ADMINISTRATORS ended with sqlCode 0.
ANR0336I Runstats for table ACTIVITY_SUMMARY started.
ANR0337I Runstats for table ACTIVITY_SUMMARY ended with sqlCode 0.
ANR0336I Runstats for table GLOBAL_ATTRIBUTES started.
ANR0337I Runstats for table GLOBAL_ATTRIBUTES ended with sqlCode 0.
ANR0336I Runstats for table ADMIN_AUTHORIZATIONS started.
ANR0337I Runstats for table ADMIN_AUTHORIZATIONS ended with sqlCode 0.
ANR0336I Runstats for table CLIENT_EVENTRULES started.
ANR0337I Runstats for table CLIENT_EVENTRULES ended with sqlCode 0.
ANR0336I Runstats for table CLIENTOPT_MEMBERS started.
ANR0337I Runstats for table CLIENTOPT_MEMBERS ended with sqlCode 0.
ANR0336I Runstats for table SERVER_CONNECT started.
ANR0337I Runstats for table SERVER_CONNECT ended with sqlCode 0.
ANR0336I Runstats for table CLIENT_OPTIONSET started.
ANR0337I Runstats for table CLIENT_OPTIONSET ended with sqlCode 0.
ANR0336I Runstats for table EXTENDED_ATTRIBUTES started.
ANR0337I Runstats for table EXTENDED_ATTRIBUTES ended with sqlCode 0.
ANR0336I Runstats for table SERVER_CONNECT_INFO started.
ANR0337I Runstats for table SERVER_CONNECT_INFO ended with sqlCode 0.
ANR0336I Runstats for table ADM_SSL_KEYRING started.
ANR0337I Runstats for table ADM_SSL_KEYRING ended with sqlCode 0.
ANR0336I Runstats for table NODE_EMAILS started.
ANR0337I Runstats for table NODE_EMAILS ended with sqlCode 0.
ANR0336I Runstats for table NODE_GROUPS started.
ANR0337I Runstats for table NODE_GROUPS ended with sqlCode 0.
ANR0336I Runstats for table NODES started.
ANR0337I Runstats for table NODES ended with sqlCode 0.
ANR0336I Runstats for table PROXYNODE_ASSOCIATIONS started.
ANR0337I Runstats for table PROXYNODE_ASSOCIATIONS ended with sqlCode 0.
ANR0336I Runstats for table SERVER_GROUP_ASSOCATION started.
ANR0337I Runstats for table SERVER_GROUP_ASSOCATION ended with sqlCode 0.
ANR0336I Runstats for table STORED_COMMANDS started.
ANR0337I Runstats for table STORED_COMMANDS ended with sqlCode 0.
ANR0336I Runstats for table SERVER_EVENTRULES started.
ANR0337I Runstats for table SERVER_EVENTRULES ended with sqlCode 0.
ANR0336I Runstats for table SERVER_GROUP started.
ANR0337I Runstats for table SERVER_GROUP ended with sqlCode 0.
ANR0336I Runstats for table SERVER_INFORMATION started.
ANR0337I Runstats for table SERVER_INFORMATION ended with sqlCode 0.
ANR0336I Runstats for table SERVER_EVENTVECTORS started.
ANR0337I Runstats for table SERVER_EVENTVECTORS ended with sqlCode 0.
ANR0336I Runstats for table TRIGGERS started.
ANR0337I Runstats for table TRIGGERS ended with sqlCode 0.
ANR0336I Runstats for table AF_BITFILES started.
ANR0337I Runstats for table AF_BITFILES ended with sqlCode 0.
ANR0336I Runstats for table AF_BACKUP_OPTIMIZATION started.
ANR0337I Runstats for table AF_BACKUP_OPTIMIZATION ended with sqlCode 0.
ANR0336I Runstats for table AF_CLUSTERS started.
ANR0337I Runstats for table AF_CLUSTERS ended with sqlCode 0.
ANR0336I Runstats for table AF_DAMAGED started.
ANR0337I Runstats for table AF_DAMAGED ended with sqlCode 0.
ANR0336I Runstats for table AF_SEGMENTS started.
ANR0337I Runstats for table AF_SEGMENTS ended with sqlCode 0.
ANR0336I Runstats for table AF_VOL_CLUSTERS started.
ANR0337I Runstats for table AF_VOL_CLUSTERS ended with sqlCode 0.
ANR0336I Runstats for table AF_VOL_PARTIAL_BITFILES started.
ANR0337I Runstats for table AF_VOL_PARTIAL_BITFILES ended with sqlCode 0.
ANR0336I Runstats for table AS_CENTERA_DELETE started.
ANR0337I Runstats for table AS_CENTERA_DELETE ended with sqlCode 0.
ANR0336I Runstats for table AS_SEGMENTS started.
ANR0337I Runstats for table AS_SEGMENTS ended with sqlCode 0.
ANR0336I Runstats for table AS_VOLUME_STATUS started.
ANR0337I Runstats for table AS_VOLUME_STATUS ended with sqlCode 0.
ANR0336I Runstats for table BF_AGGREGATE_ATTRIBUTES started.
ANR0337I Runstats for table BF_AGGREGATE_ATTRIBUTES ended with sqlCode 0.
ANR0336I Runstats for table BF_BITFILE_EXTENTS started.
ANR0337I Runstats for table BF_BITFILE_EXTENTS ended with sqlCode 0.
ANR0336I Runstats for table BF_AGGREGATED_BITFILES started.
ANR0337I Runstats for table BF_AGGREGATED_BITFILES ended with sqlCode 0.
ANR0336I Runstats for table COLLOCATION_GROUPS started.
ANR0337I Runstats for table COLLOCATION_GROUPS ended with sqlCode 0.
ANR0336I Runstats for table BF_DEREFERENCED_CHUNKS started.
ANR0337I Runstats for table BF_DEREFERENCED_CHUNKS ended with sqlCode 0.
ANR0336I Runstats for table COLLOCATION_GROUP_MEMBER started.
ANR0337I Runstats for table COLLOCATION_GROUP_MEMBER ended with sqlCode 0.
ANR0336I Runstats for table BF_QUEUED_CHUNKS started.
ANR0337I Runstats for table BF_QUEUED_CHUNKS ended with sqlCode 0.
ANR0336I Runstats for table BF_SHRED_BITFILES started.
ANR0337I Runstats for table BF_SHRED_BITFILES ended with sqlCode 0.
ANR0336I Runstats for table BV_MASTER_SUPERNODE started.
ANR0337I Runstats for table BV_MASTER_SUPERNODE ended with sqlCode 0.
ANR0336I Runstats for table PROFILE_ASSOCIATIONS started.
ANR0337I Runstats for table PROFILE_ASSOCIATIONS ended with sqlCode 0.
ANR0336I Runstats for table PROFILES started.
ANR0337I Runstats for table PROFILES ended with sqlCode 0.
ANR0336I Runstats for table PROFILE_OBJECT_NAMES started.
ANR0337I Runstats for table PROFILE_OBJECT_NAMES ended with sqlCode 0.
ANR0336I Runstats for table SUBSCRIPTIONS started.
ANR0337I Runstats for table SUBSCRIPTIONS ended with sqlCode 0.
ANR0336I Runstats for table SCHEDULE_ASSOCATION started.
ANR0337I Runstats for table SCHEDULE_ASSOCATION ended with sqlCode 0.
ANR0336I Runstats for table SCHEDULES started.
ANR0337I Runstats for table SCHEDULES ended with sqlCode 0.
ANR0336I Runstats for table SCHEDULE_EVENT started.
ANR0337I Runstats for table SCHEDULE_EVENT ended with sqlCode 0.
ANR0336I Runstats for table SCHEDULE_NODE_ADDRESSES started.
ANR0337I Runstats for table SCHEDULE_NODE_ADDRESSES ended with sqlCode 0.
ANR0336I Runstats for table SCHEDULE_PENDING started.
ANR0337I Runstats for table SCHEDULE_PENDING ended with sqlCode 0.
ANR0336I Runstats for table DB_INFO started.
ANR0337I Runstats for table DB_INFO ended with sqlCode 0.
ANR0336I Runstats for table DF_BITFILES started.
ANR0337I Runstats for table DF_BITFILES ended with sqlCode 0.
ANR0336I Runstats for table DF_CACHEDBITFILES started.
ANR0337I Runstats for table DF_CACHEDBITFILES ended with sqlCode 0.
ANR0336I Runstats for table DF_CLUSTERS started.
ANR0337I Runstats for table DF_CLUSTERS ended with sqlCode 0.
ANR0336I Runstats for table DF_DAMAGED started.
ANR0337I Runstats for table DF_DAMAGED ended with sqlCode 0.
ANR0336I Runstats for table DF_MIGRCANDIDATES started.
ANR0337I Runstats for table DF_MIGRCANDIDATES ended with sqlCode 0.
ANR0336I Runstats for table DF_MIGRBITFILES started.
ANR0337I Runstats for table DF_MIGRBITFILES ended with sqlCode 0.
ANR0336I Runstats for table DF_SEGMENTS started.
ANR0337I Runstats for table DF_SEGMENTS ended with sqlCode 0.
ANR0336I Runstats for table DRM_MACH_CHAR started.
ANR0337I Runstats for table DRM_MACH_CHAR ended with sqlCode 0.
ANR0336I Runstats for table DRM_MACHINE_DEFINITION started.
ANR0337I Runstats for table DRM_MACHINE_DEFINITION ended with sqlCode 0.
ANR0336I Runstats for table DRM_MACHNAME_MACHID started.
ANR0337I Runstats for table DRM_MACHNAME_MACHID ended with sqlCode 0.
ANR0336I Runstats for table DRM_MACH_NODE started.
ANR0337I Runstats for table DRM_MACH_NODE ended with sqlCode 0.
ANR0336I Runstats for table DRM_RM_MACH_ASSOCIATION started.
ANR0337I Runstats for table DRM_RM_MACH_ASSOCIATION ended with sqlCode 0.
ANR0336I Runstats for table DRM_REC_INST started.
ANR0337I Runstats for table DRM_REC_INST ended with sqlCode 0.
ANR0336I Runstats for table DRM_RECOV_MEDIA started.
ANR0337I Runstats for table DRM_RECOV_MEDIA ended with sqlCode 0.
ANR0336I Runstats for table DS_INFLIGHT_SEGMENTS started.
ANR0337I Runstats for table DS_INFLIGHT_SEGMENTS ended with sqlCode 0.
ANR0336I Runstats for table DS_OVERFLOW started.
ANR0337I Runstats for table DS_OVERFLOW ended with sqlCode 0.
ANR0336I Runstats for table DS_SEGMENTS started.
ANR0337I Runstats for table DS_SEGMENTS ended with sqlCode 0.
ANR0336I Runstats for table DS_VOLUME_STATUS started.
ANR0337I Runstats for table DS_VOLUME_STATUS ended with sqlCode 0.
ANR0336I Runstats for table SEQ_VOLUME_HISTORY started.
ANR0337I Runstats for table SEQ_VOLUME_HISTORY ended with sqlCode 0.
ANR0336I Runstats for table AUTHORIZATION_RULES started.
ANR0337I Runstats for table AUTHORIZATION_RULES ended with sqlCode 0.
ANR0336I Runstats for table EXPIRATION_RESTART started.
ANR0337I Runstats for table EXPIRATION_RESTART ended with sqlCode 0.
ANR0336I Runstats for table FILESPACES started.
ANR0337I Runstats for table FILESPACES ended with sqlCode 0.
ANR0336I Runstats for table GROUP_LEADERS started.
ANR0337I Runstats for table GROUP_LEADERS ended with sqlCode 0.
ANR0336I Runstats for table IMPORT_GROUPS started.
ANR0337I Runstats for table IMPORT_GROUPS ended with sqlCode 0.
ANR0336I Runstats for table LONG_OBJECTS started.
ANR0337I Runstats for table LONG_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table NODEID_ASSIGNMENT started.
ANR0337I Runstats for table NODEID_ASSIGNMENT ended with sqlCode 0.
ANR0336I Runstats for table OBJECT_SET_FILESPACES started.
ANR0337I Runstats for table OBJECT_SET_FILESPACES ended with sqlCode 0.
ANR0336I Runstats for table GROUP_OBJECTS_BYLEADER started.
ANR0337I Runstats for table GROUP_OBJECTS_BYLEADER ended with sqlCode 0.
ANR0336I Runstats for table OBJECT_POSITION started.
ANR0337I Runstats for table OBJECT_POSITION ended with sqlCode 0.
ANR0336I Runstats for table RESTORE_SESSIONS started.
ANR0337I Runstats for table RESTORE_SESSIONS ended with sqlCode 0.
ANR0336I Runstats for table RESTORE_SRVOBJ started.
ANR0337I Runstats for table RESTORE_SRVOBJ ended with sqlCode 0.
ANR0336I Runstats for table SPACEMANEXT_OBJECTS started.
ANR0337I Runstats for table SPACEMANEXT_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table SORTED_OBJECTS started.
ANR0337I Runstats for table SORTED_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table UNRESOLVED_LEADERS started.
ANR0337I Runstats for table UNRESOLVED_LEADERS ended with sqlCode 0.
ANR0336I Runstats for table UNRESOLVED_OBJECTS started.
ANR0337I Runstats for table UNRESOLVED_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table VFSMAPPINGS started.
ANR0337I Runstats for table VFSMAPPINGS ended with sqlCode 0.
ANR0336I Runstats for table EXPIRATION_RETRY started.
ANR0337I Runstats for table EXPIRATION_RETRY ended with sqlCode 0.
ANR0336I Runstats for table LICENSE_DETAILS started.
ANR0337I Runstats for table LICENSE_DETAILS ended with sqlCode 0.
ANR0336I Runstats for table LICENSES started.
ANR0337I Runstats for table LICENSES ended with sqlCode 0.
ANR0336I Runstats for table LICENSE_NODE_STORAGE started.
ANR0337I Runstats for table LICENSE_NODE_STORAGE ended with sqlCode 0.
ANR0336I Runstats for table LICENSE_SUMMARY started.
ANR0337I Runstats for table LICENSE_SUMMARY ended with sqlCode 0.
ANR0336I Runstats for table MMS_DRIVES started.
ANR0337I Runstats for table MMS_DRIVES ended with sqlCode 0.
ANR0336I Runstats for table MMS_LIBRARIES started.
ANR0337I Runstats for table MMS_LIBRARIES ended with sqlCode 0.
ANR0336I Runstats for table MMS_LIB_INVENTORY started.
ANR0337I Runstats for table MMS_LIB_INVENTORY ended with sqlCode 0.
ANR0336I Runstats for table NA_DISK started.
ANR0337I Runstats for table NA_DISK ended with sqlCode 0.
ANR0336I Runstats for table NA_DATAMOVER started.
ANR0337I Runstats for table NA_DATAMOVER ended with sqlCode 0.
ANR0336I Runstats for table NA_PATH started.
ANR0337I Runstats for table NA_PATH ended with sqlCode 0.
ANR0336I Runstats for table BACKUPSET_TEMP_OBJECTS started.
ANR0337I Runstats for table BACKUPSET_TEMP_OBJECTS ended with sqlCode 0.
ANR0336I Runstats for table BACKUPSET_GROUP_LEADERS started.
ANR0337I Runstats for table BACKUPSET_GROUP_LEADERS ended with sqlCode 0.
ANR0336I Runstats for table COPY_GROUPS started.
ANR0337I Runstats for table COPY_GROUPS ended with sqlCode 0.
ANR0336I Runstats for table COPY_GROUP_IDS started.
ANR0337I Runstats for table COPY_GROUP_IDS ended with sqlCode 0.
ANR0336I Runstats for table POLICY_DOMAIN_MEMBERS started.
ANR0337I Runstats for table POLICY_DOMAIN_MEMBERS ended with sqlCode 0.
ANR0336I Runstats for table MANAGEMENT_CLASSES started.
ANR0337I Runstats for table MANAGEMENT_CLASSES ended with sqlCode 0.
ANR0336I Runstats for table MANAGEMENT_CLASS_IDS started.
ANR0337I Runstats for table MANAGEMENT_CLASS_IDS ended with sqlCode 0.
ANR0336I Runstats for table POLICY_DOMAINS started.
ANR0337I Runstats for table POLICY_DOMAINS ended with sqlCode 0.
ANR0336I Runstats for table POLICY_SETS started.
ANR0337I Runstats for table POLICY_SETS ended with sqlCode 0.
ANR0336I Runstats for table POLICY_STGPOOL_LIMITS started.
ANR0337I Runstats for table POLICY_STGPOOL_LIMITS ended with sqlCode 0.
ANR0336I Runstats for table SS_CLASSES started.
ANR0337I Runstats for table SS_CLASSES ended with sqlCode 0.
ANR0336I Runstats for table DEVCLASS_DIRS started.
ANR0337I Runstats for table DEVCLASS_DIRS ended with sqlCode 0.
ANR0336I Runstats for table SS_POOL_CONTENTS started.
ANR0337I Runstats for table SS_POOL_CONTENTS ended with sqlCode 0.
ANR0336I Runstats for table SS_POOLS started.
ANR0337I Runstats for table SS_POOLS ended with sqlCode 0.
ANR0336I Runstats for table SS_VOLUME_IDS started.
ANR0337I Runstats for table SS_VOLUME_IDS ended with sqlCode 0.
ANR0336I Runstats for table TEMP_SQL_VOLUMEUSAGE started.
ANR0337I Runstats for table TEMP_SQL_VOLUMEUSAGE ended with sqlCode 0.
ANR0336I Runstats for table TEMP_EXPORTED_OBJECTS started.
ANR0337I Runstats for table TEMP_EXPORTED_OBJECTS ended with sqlCode 0.
ANR0136I Table updating statistics performed successfully for 117 of 117.
ANR1528I RUNSTATS: Table updating statistics completed in 0:01:44.
ANR0369I Stopping the database manager because of a server shutdown.
Tags: , , , ,

  • 1
(Deleted comment)
*quickly adjusts post* Yes, 6.2.3, not 6.3. Sorry.

My biggest problems were due to OS upgrade. I was running 5.5 on XP, and 6.2 won't install on XP. (6.3 client won't either).

There's no "upgrade" from XP to 2008, so I had to reinstall, then reinstall all of my apps, etc. TSM was last. You can't just point to the old DB like you can on AIX/Linux. You have to re-add the server instance. Documentation was very spotty on this, because the assumption is that you'll reinstall, build a new TSM, then restore your DB. I wanted to attach to my existing instance.

Ultimately, "dsmupgd.exe update" did it for me.

23 mins for upgrade, and source DB and LOG were on one SATA disk with the OS, and the target TSM DB was on the same disk. Amazingly, I still got over 6GB/hr out of it. My cap was mostly due to IOPS limitation. I was pegged just over 100. MBPS wasn't pegged, and CPU only pegged during the extract.

Luckily, I have a shiny used 2.6GHz 8MB quad-core waiting at home for me to install it.

Unfortunately, the box maxed out at 8GB ram, though luckily for me, TSM 6.2.3 only uses 144MB RAM plus, plus 2996MB for the DB2 process, plus 2.5 megs per additional (non-idle) thread. Even during backups and dedupe processing and etc, it's very manageable.


(Deleted comment)
In answer to the question, TSM client 6.3 refused to install on XP. That's why I upgraded my OS (to 2008 R2 DC x64).

Beside that, replacing the OS drive on any TSM Server installation is always difficult. It has nothing to do with change in versions or statements of support. "Support" is an excuse for limiting the cost to provide software maintenance. There is no functional reason that any of it should not run other than VSS, which isn't really baked in XP.

The difficulty is that there are tools to do it, but it's not documented very well. There are clear directions for installing new, and for restoring the database, but not for reattaching to an existing database after OS reinstall.

Because TSMS reattach to existing DB is a PITA, I upgraded TSMS to 6.2. It just wasn't really any easier.

Another fun thing is that, upgrading TSMS 5.5 to 6.2 requires installing TSMC 6.1. TSMC 6.2 uses GSK8 and the upgrade tools require GSK7.

Unfortunately, now, with DB2, I think a reinstall of the OS drive would be even more difficult to reattach, pretty much ensuring that I must do a DB restore. I'm not sure though. I might be able to create an instance onto a dummy drive, shut down DB2, then swap in the proper drive.

(Deleted comment)
Weird. I don't know why it didn't like me then. I was at current patch levels, etc. Maybe I was a moron and clicked on the 64-bit client installer.

and yah, I know swma is expensive, especially when guaranteeing support for X time, and guaranteeing bug fixes for Y time. I don't think it's unjustified from a financial standpoint, but in a test lab, or play systems, I think "support" vs "enforced" often are co-mingled. (We don't have to pay to support sneaky people, or to turn away honest customers, if the product simply won't install...)

And yah, home, but work to do which I've been unmotivated to do because of fatigue.

  • 1