About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
An EXPORT NODE command is run to export a node from one server to another. The export fails with the ANR9999D message and error 1115.
Symptom
The "EXPORT NODE Node1 fsid=1 TOServer=server2" command is used to export node1 to server2 and the process fails immediately with the following messages logged in the activity log of the source Tivoli Storage Manager server.
ANR0635I EXPORT NODE: Processing node Node1 in domain DOM1 (SESSION: 1234, PROCESS: 5678)
ANR0637I EXPORT NODE: Processing file space /FS1 for node NODE1 fsId 1 . (SESSION: 1234, PROCESS: 5678)
ANR9999D_2717517387 SortProcessKeys(imxi.c:4510) Thread<410368>: Error 1115 creating temporary table. (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> issued message 9999 from: (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000d6d4e3 OutDiagToCons (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000d702e5 outDiagfExt (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000896e56 SortProcessKeys (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x0000000089e366 imExportObjects (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000be7807 SmQryExportObjects (SESSION:1234, PROCESS:5678)
ANR9999D Thread<410368> 0x00000000c3a089 DoExportImportVerbs (SESSION:1234,PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000c3c348 SmAdminSession (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000b0f10c DoAdminGeneral (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000b15d5b smExecuteSession (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000dee5ce XiSessionThread (SESSION:1234, PROCESS: 5678)
ANR9999D Thread<410368> 0x00000000dfeaf6 StartThread (SESSION:1234, PROCESS: 5678)
ANR0562I EXPORT NODE: Data transfer complete, deleting temporary data. (SESSION:1234, PROCESS: 5678)
ANR0728E EXPORT NODE: Processing terminated abnormally - internal error. (SESSION:1234, PROCESS: 5678)
Cause
During a Server to Server export process or restartable export process, temporary data will be stored in temporary tables using the "TSMTEMP" tablespace. If for any reason the "TSMTEMP" tablespace is missing or in abnormal status, the restartable export process can fail.
Diagnosing The Problem
Login as the instance owner and run the "db2 list tablespaces " command to list existing tablespace. in this specific case, the "TSMTEMP" did not exist.
Resolving The Problem
Follow the steps below to recreate the missing TSMTEMP tablespace.
- Halt Tivoli Storage Manager Server
- Login as the instance owner and run the following commands :
$db2start
$db2 connect to tsmdb1
$db2 "CREATE USER TEMPORARY TABLESPACE "TSMTEMP" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 16384 MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 32 PREFETCHSIZE 32 BUFFERPOOL IBMDEFAULTBP OVERHEAD 10.500000 TRANSFERRATE 0.140000 FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF"'
Verify that the TSMTEMP tablespace is created and is in normal status with the following command :
[ - Restart the Tivoli Storage Manager server and re-run the export process
db2 llist tablespaces show detail
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager
Software version:
All Supported Versions
Document number:
265551
Modified date:
17 June 2018
UID
swg21966298