APAR status
Closed as fixed if next.
Error description
When submitting a dsmadmc select command against the DRMTRPF, e.g. "select * from DRMTRPF" to query Tivoli Storage Manager recovery plan files, the following error might be reported: ANR0102E admsql.c(5462): Error 1202 inserting row in table "DRMTRPF". The symptom is seen if two or more servers - define their device class for recovery plan file to the same target server and - the servers run a PREPARE command at the same time up to the second. This will generate two plan files with the same name: The naming convention for the archive object that contains the recovery plan file on the target server is: Filespace name: ADSM.SERVER High-level qualifier: devclassprefixルservername.yyyymmdd.hhmmss Low-level qualifier: RPF.OBJ.1 The recovery plan file virtual volume name as recorded in the volume history table on the source server is in the format servername.yyyymmdd.hhmmss. Tivoli Storage Manager Versions Affected: all V6 Initial Impact: Low Additional Keywords: TSM TSMDB1 DRM SQL DB2 Archive_Nameview
Local fix
use the QUERY RPF instead To prevent from the symptom, do not run PREPARE commands for multiple server nodes to the same target server at the same time
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: * **************************************************************** This problem is projected to be fixed in a future version of the Tivoli Storage Manager server. Note that this is subject to change at the discretion of IBM.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IC95021
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63L
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-20
Closed date
2013-08-23
Last modified date
2013-08-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63L","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
23 August 2013