Fixes are available
APAR status
Closed as program error.
Error description
An ANR0102E error 8 inserting row in table adminst message is issued when a select statement is run against the admins table. This can be caused by issuing the command manually or if it is entered by another process. An example of this would be when adding a server connection in the Administration Center. It is possible for the length of the data being inserted into a column in the table to be longer thanthe defined length for that column. TSM Versions Affected: TSM 6.1 servers on all platforms Customer/L2 Diagnostics: A trace with flags DB, DBEXEC, and ADM will show the value that is being entered into the adminst. For example: [tbcli.c][9778][TraceSetInputParameters]:col=8, name=STORAGE_PRIV, type=STRING, value=XXXXXX If the length of this value is greater than the length of field in the table, the error will occur Initial Impact: Low Additional Keywords: ANR0162W, ANR0157W, ANR0158W, Admin Center, AC, add server connection, ADMIN_CENTER, admins, adminst, zz61
Local fix
It may be possible to reduce the length of the data being inserted into the temporary table by reducing the length of some of the attributes of the failing adminstrator.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager 6.1 Windows and * * UNIX servers using the Administrative * * Client. * **************************************************************** * PROBLEM DESCRIPTION: See error description * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in level 6.1.2. Note that this is * * subject to change at the discretion of IBM * **************************************************************** *
Problem conclusion
This problem was fixed.
Temporary fix
Comments
APAR Information
APAR number
IC61009
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
55W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-05-05
Closed date
2009-06-05
Last modified date
2009-06-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
[{"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":"55W"}]
Document Information
Modified date:
15 September 2021