OnDemand Server Migration & Upgrade

[rellerbrock]

I am attempting to migrate and upgrade OnDemand on a new server.  During the migration process I am attempting to change the user that runs the OnDemand services.  This is being asked to be done for security reasons.  I was able to get the library service running but I  am unable to retrieve documents from TSM.

Old:
Windows 2008 R2 SP1
DB2 9.7 FP11
OnDemand 8.5.0.4
TSM Client 6.4.2

New:
Windows Server 2012 R2
DB2 10.5 FP7
OnDemand 9.5.0.4
TSM Client 6.4.2 (also tried 7.1)

TSM Server (separate & unchanged)
Windows 2008 R2
TSM Server 6.3.4

In order to change the OnDemand admin user I used the db2look & db2move to export/import the schema and data to a new schema for new user.

The problem is that when I attempt to retrieve a document stored to TSM I get "The server failed while retrieving a document".

System Log shows the following 2 entries.
TSM Error: ANS1088E (RC124)  File space '*' does not exist, Return Code=124, Reason=0, File=arssmsms.cpp, Line=1893

Object >1040FAAA< in Application Group >TOD< not found in node >OD_TEST_NODE< 

I enabled TSM traces on both servers and found differences in the way OnDemand is retrieving the documents from TSM.

Old Server
[004556] [4336] : dsmquery.cpp        ( 891): dsmBeginQuery: function started fs= >\TOD< hl= >\DOC< ll= >\1038FAAA<

New Server 
[006724] [5824] : dsmquery.cpp        ( 891): dsmBeginQuery: function started fs= >\ARCHIVE\TOD< hl= >\DOC< ll= >\1033FAAA<

It looks like the new server is adding the instance name "ARCHIVE" to the TSM query.   IBM support is telling me that it will only add the instance name (ARCHIVE) if the instance name is not ARCHIVE.

I also tried to just backup and restore the database from old to new server using the original admin username but got the same results.

Any suggestions on how to make the new server perform TSM retrievals the same way as the old?

[Justin Derrick]

Can you share a screen shot or summary of the parameters in the Configurator?

[rellerbrock]

Here is output from the ">arssockd.exe -h ARCHIVE -q".   Let me know if you need more information.

Command:                      ARSSOCKD
Version:                      9.5.0.4
Operating System:             Windows 64
Operating System Version:     6.3.9600.17031
Database:                     DB2
Database Version:             10.05.0007
Storage Manager:              TSM
Storage Manager Version:      6.4.2.0
Instance:                     ARCHIVE

Data (KB):                    0
Stack (KB):                   0
Core (512-blocks)             0
Cpu (seconds):                0
File (512-blocks)             0
Nofiles:                      0
Threads:                      0
Processes:                    0

[@SRV@_ARCHIVE]
PORT=0
HOST=VSDVWOD01
DIRECTORY=
SRVR_OD_CFG=CFG
SRVR_INSTANCE=ARCHIVE
SRVR_INSTANCE_OWNER=OD
SRVR_INSTANCE_DATE=1454354309
SRVR_FLAGS_SECURITY_EXIT=0
SRVR_FLAGS_IGNORE_PASSWD_MAX=1
SSL_KEYRING_FILE=C:\Program Files\IBM\OnDemand\V9.5\config\ondemand.kdb
SSL_KEYRING_STASH=C:\Program Files\IBM\OnDemand\V9.5\config\ondemand.sth
SSL_KEYRING_LABEL=IBM Content Manager OnDemand
SSL_CLNT_USE_SSL=0
SSL_PORT=0
SRVR_OD_STASH=C:\Program Files\IBM\OnDemand\V9.5\config\ARCHIVE.stash
VERSION=9.5
PROTOCOL=2

[CFG]
ARS_SRVR=
ARS_LOCAL_SRVR=
ARS_NUM_DBSRVR=8
ARS_NUM_LICENSE=2000
ARS_LANGUAGE=ENU
ARS_CODEPAGE=1252
ARS_TMP=e:\arstmp
ARS_PRINT_PATH=e:\arstmp
ARS_DB_IMPORT=0
ARS_DB_TABLE_SHARE=
ARS_DB_RUNSTATS_SHARE=
ARS_DB_RUNSTATS_OPTIONS=
ARS_DB_PARTITION=
DB_ENGINE=DB2
ARS_DB2UEXIT_AUDIT=0
ARS_DB2UEXIT_BUFSIZE=65536
ARS_DB2_ADSM_FOR_LOG=0
ARS_DB2_DATABASE_PATH=D:\
ARS_DB2_PRIMARY_LOGPATH=d:\arsdbpri
ARS_DB2_ARCHIVE_LOGPATH=d:\arsdbarc
ARS_DB2_LOGFILE_SIZE=1000
ARS_DB2_LOG_NUMBER=64
ARS_DB2_ADSM_CONFIG=
ARS_STORAGE_MANAGER=ADSM
ARS_USE_IFORLS=0
DSMI_DIR=C:\Program Files\Tivoli\TSM\baclient
DSMI_CONFIG=C:\Program Files\Tivoli\TSM\baclient\dsm_od.opt
DSMI_LOG=e:\arstmp
ARS_LDAP_SERVER=
ARS_LDAP_PORT=
ARS_LDAP_BASE_DN=
ARS_LDAP_BIND_DN=
ARS_LDAP_BIND_DN_PWD=
ARS_LDAP_BIND_ATTRIBUTE=
ARS_LDAP_MAPPED_ATTRIBUTE=
ARS_LDAP_BIND_MESSAGES_FILE=
ARS_LDAP_ALLOW_ANONYMOUS=
ARS_SUPPORT_HOLD=0
ARS_SUPPORT_CFSOD=
ARS_LDAP_OD_AUTHORITY_FALLBACK=TRUE
ARS_LDAP_USE_SSL=
ARS_LDAP_KEYRING_FILE=C:\Program Files\IBM\OnDemand\V9.5\config\ondemand.kdb
ARS_ORIGINAL_CODEPAGE=5348
ARS_LDAP_IGN_USERIDS=ADMIN,OD
ARS_LDAP_KEYRING_LABEL=IBM Content Manager OnDemand LDAP
ARS_SUPPORT_FULL_TEXT_INDEX=0
ARS_MESSAGE_OF_THE_DAY=
ARS_LISTENER_PORT=
ARSODF_TMP=E:\arstmp
ARSODF_FILE_LOCATION=E:\arsprint
ARS_JAVA_CMD=C:\Program Files\IBM\OnDemand\V9.5\jre\jre\bin\java.exe
ARSODF_PRINTTASKS=2
ARSODF_DISTSLEEP=300
ARSODF_CONTSLEEP=600
ARSODF_SCHDSLEEP=300
ARS_DOWNLOAD_DIR=e:\arstmp
ARS_DOWNLOAD_TMP_DIR=e:\arstmp
ARS_TRACE_SETTINGS=C:\Program Files\IBM\OnDemand\V9.5\config\trace.settings

[DBFS]
DBFS1=d:\arsdbfs
DBFS_NUM=1

[CACHE]
SMFS1=d:\arscache
SMFS_NUM=1

[Alessandro Perucchi]

so you have 2 choices :-)

1) Fill a bug report in your PMR, saying that CMOD search for \ARCHIVE\TOD instead of \TOD.

2) You can from TSM rename the filespace -> the command is    "rename filespace \TOD \ARCHIVE\TOD"
(maybe you need to add the node name in the command...)

Normally the second choice, is when you need to change the name of the database for some naming conventions...

[rellerbrock]

IBM Development has determined there is a defect in the CMOD <-> TSM interface in 9.5.0.4.  I was able to install 9.5.0.3 and successfully retrieve documents from TSM.