A fix is available
APAR status
Closed as program error.
Error description
When issuing a SELECT statement against the Tivoli Storage Manager Server "events" table using command " SELECT * from Events", The command can fail with the following error logged in activity log: . ANR0102E admsql.c(5299): Error 1 inserting row in table "EVENTS.SQL". . . Customer/L2 Diagnostics: The error condition can happen if there are duplicated event records and the NODE_NAME field is NULL: for example, A trace on the failed command with flags "ADDMSG ADM DB DBEXEC SQL SCHED" shows 13:32:30.229 [148][tbcli.c][10226][TraceSetInputParameters]:key=2, name=NODE_NAME, type=STRING, value=(0)addr-0x11108d4c4 ... 13:32:31.130 [148][tbcli.c][10226][TraceSetInputParameters]:key=2, name=NODE_NAME, type=STRING, value=(0)addr-0x11108d4c4 Tivoli Storage Manager Versions Affected: All 6.1 and 6.2 Tivoli Storage Manager Servers. . Additional Keywords: ZZ62 ZZ61 SELECT EVENTS ANR0102E IC69139 .
Local fix
Use the QUERY EVENT command (type=client & type=admin).
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users * * performing a SELECT from the Events table. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.1.4.3, 6.1.5, and 6.2.2. Note * * that this is subject to change at the * * discretion of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: AIX, HP-UX, Sun Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IC71570
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-29
Closed date
2010-11-05
Last modified date
2010-11-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R61A PSY
UP
R61H PSY
UP
R61L PSY
UP
R61S PSY
UP
R61W PSY
UP
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A"}]
Document Information
Modified date:
17 September 2021