mercoledì 6 novembre 2013

TSM: Update/ Upgrade Tsm from 6.1 to 6.3



If the server that you are upgrading is at a release level earlier than V6.1.5.10, review Technote 1452146.
  • Log in by using the administrative user ID that was used to install the Tivoli Storage Manager server.
  • Verify that you have enough space to store the installation files when they are extracted from the product package.
  • To ensure that your system meets all requirements, locate the following file and run it: prereqcheck.exe

Congratulations! All checks were successful.
The results were copied into C:\Users\ADMINI~1\AppData\Local\Temp\2\prereqcheck.log

==================================================
Summary of Tivoli Storage Manager prerequisite checks
==================================================
** Requirement Checks ** Checking available memory: Warning - Tivoli Storage Manager Server - Total physical memory: 8.191 MB - Minimum memory required: 4,096 MB - Recommended memory: 12,278 MB - Recommended memory for deduplication: 16,374 MB Creating directory C:\Program Files\Tivoli\TSM: Already exists Checking Windows architecture: OK - This system is a Windows 64-bit Checking C:\: OK - available space: 7.199.662.080 bytes - required space: 209.715.200 bytes ================================================== ** Platform Checks ** Operating system (OS) name: Windows Server 2008 R2 OS version: 6.1 build 7601 Service Pack 1 Architecture: amd64 ================================================== ** Overall Results ** Platform check: OK Version check: OK Architecture check: OK Requirement check: OK Environment settings: OK ==================================================

Click Done to quit the prerequisite checker.


  • Back up the V6.1 server database and configuration files.
Copy Server1 e backup DB
  • Back up the Deployment Engine by issuing the following commands:
cd "C:\Program Files\IBM\Common\acsi"
setenv.cmd
cd "C:\Program Files\IBM\Common\acsi\bin"
de_backupdb.cmd

ACUDB0004I E' stato immesso un comando di backup database, ma la directory C:\Program Files (x86)\IBM\Common\acsi\backupDBs, la directory predefinita in cui vengono memorizzate le informazioni relative al backup database, non esiste. Deployment Engine creerà la directory.
Esecuzione backup database in C:\Program Files (x86)\IBM\Common\acsi\backupDBs\201204171120 in corso attendere ...
Richiesta completata con esito positivo.


  • Ensure that all client activity and server processes are stopped.
Q sess Q proc
  • In the server instance directory of your installation, delete or rename the nodelock file


  • For each existing server instance, gather information about the corresponding DB2 instance. Note the default database path, database name, database alias, database path, and any DB2 variables configured for the instance

C:\Program Files\Tivoli\TSM\db2\BIN>db2ilist
SERVER1

C:\Program Files\Tivoli\TSM\db2\BIN>db2 get dbm cfg | findstr DFTDBPATH
Percorso database predefinito (DFTDBPATH) = C:

C:\Program Files\Tivoli\TSM\db2\BIN>db2 list database directory
Directory del database di sistema
Numero di voci nella directory = 1
Voce di database 1:
Alias del database = TSMDB1
Nome database = TSMDB1
Directory database locale = C:
Livello di rilascio database = d.00
Commento = TSM SERVER DATABASE
Tipo voce di directory = Indiretto
Numero partizione database catalogo = 0
Nome host server alternativo =
Numero porta server alternativo =

C:\Program Files\Tivoli\TSM\db2\BIN>db2set -all
[e] DB2PATH=C:\Program Files\Tivoli\TSM\db2
[i] DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500
[i] DB2_SKIPINSERTED=ON
[i] DB2_KEEPTABLELOCK=ON
[i] DB2_EVALUNCOMMITTED=ON
[i] DB2_VENDOR_INI=c:\PROGRA~1\tivoli\tsm\server1\tsmdbmgr.env
[i] DB2_SKIPDELETED=ON
[i] DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2TSM1
[i] DB2_PARALLEL_IO=*
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=W2008R2-TSM
[g] DB2PATH=C:\Program Files\Tivoli\TSM\db2
[g] DB2INSTDEF=SERVER1



Avvio Servizio da errore altri prog stanno usando....


All'avvio da dos

C:\Users\Administrator>cd "\Program Files\Tivoli\TSM"\server

C:\Program Files\Tivoli\TSM\server>dsmserv
ANR7800I DSMSERV generated at 01:07:23 on Feb 22 2012.
Tivoli Storage Manager for Windows
Version 6, Release 3, Level 1.000
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2011.
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:\program files\tivoli\tsm\server1\dsmserv.opt.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR1380I The buffer pool monitor switch is enabled.
ANR1628I The database manager is using port 51500 for server connections.
ANR0162W Supplemental database diagnostic information: -1:38553:-443 ([IBM][CLI Driver][DB2/NT64] SQL0443N La routine definita dall'utente "SYSIBM.SQLTABLES" (nome specifico "TABLES") ha restituito un errore SQLSTATE con il testo diagnostico "SYSIBM:CLI:-805". SQLSTATE=38553).
ANR9999D_3097613448 InitDBInfo(dbiinit.c:2121) Thread<0>: Error 9999 registering table DB.Info.
ANR9999D Thread<0> issued message 9999 from:
ANR9999D Thread<0> 000007FEE7826A99 OutDiagToCons()+159
ANR9999D Thread<0> 000007FEE78204EC outDiagfExt()+fc
ANR9999D Thread<0> 000007FEE7583EC0 dbUpgradeComplete()+940
ANR9999D Thread<0> 000007FEE7584F04 dbiInit()+8d4
ANR9999D Thread<0> 000007FEE705CE58 admDisplayDBSpace()+5c8
ANR9999D Thread<0> 000007FEE705E58B admStartServer()+cb
ANR9999D Thread<0> 000007FEE7043434 adsmMain()+e64
ANR9999D Thread<0> 000000013F5A111B main()+9b dsmserv.c:241
ANR9999D Thread<0> 000000013F5A28DA __tmainCRTStartup()+11a crtexe.c:555
ANR9999D Thread<0> 000000007686652D BaseThreadInitThunk()+d
ANR9999D Thread<0> 0000000076F5C521 RtlUserThreadStart()+21


These errors are general DB2 errors and it seemed that there was a database problem before the upgrade and the upgrade was not applied correctly.

The correct procedure would be to reinstall TSM 6.3.0.0 and restore the database but the other way to solve this issue is to manually rebind the DB2 database schemas. Please keep in mind that this is not recommended if you do not have a valid database backup.

On a default installation of TSM 6.x.x, the command syntax would look like this:

db2start
db2 terminate
db2 CONNECT TO tsmdb1
db2 BIND C:\Progra~1\Tivoli\TSM\db2\bnd\db2schema.bnd BLOCKING ALL GRANT PUBLIC
SQLERROR CONTINUE
db2 BIND C:\Progra~1\Tivoli\TSM\db2\bnd\@db2ubind.lst BLOCKING ALL GRANT PUBLIC
ACTION ADD
db2 BIND C:\Progra~1\Tivoli\TSM\db2\bnd\@db2cli.lst BLOCKING ALL GRANT PUBLIC
ACTION ADD
db2 terminate


Please note that packages that are already bound will return an SQL0719N error. This is expected.