IT04858: CREATING, EDITING AND QUERYING THE CLIENT SCHEDULES MAY FAIL IF THESE HAVE A DURATION OF "INDEFINITE"

7.1.1.100-TIV-TSMSRV-WIN
7.1.1.100-TIV-TSMSRV-SolarisSPARC
7.1.1.100-TIV-TSMSRV-Linuxppc64
7.1.1.100-TIV-TSMSRV-HP-UX
7.1.1.100-TIV-TSMSRV-Linuxppc64
7.1.1.100-TIV-TSMSRV-Linuxs390x
7.1.1.100-TIV-TSMSRV-Linuxx86_64
7.1.1.100-TIV-TSMSRV-AIX
IBM Tivoli Storage Manager (TSM) server V7.1.1.x interim fix downloads

APAR status

• Closed as program error.

Error description

• When creating, editing or querying Tivoli Storage Manager Client
  schedules using Operations Center, the operation may fail with
  the following error:
  
  "ANRG0092E: An internal error occurred on the Tivoli Storage
  Manager Server"
  
  Also, the following exceptions will be logged into the Activity
  Log:
  
  ANR9999D_2215375891 DoTheParmBinds(tbcli.c:8225) Thread<71>:
  Type mismatch 21 != 31 for column 14 for row 000000000D1CC680
  ......
  
   ANR0102E admsql.c(5734): Error 9999 inserting row in table
  "cli_schedt".
  
  
  The problem will also take place when performing select
  against "client_schedules" table using the Tivoli Storage
  Manager Administrative Command Line (dsmadmc).
  This issue will only occur with Client schedules that have a
  "durunits" field set to "indefinite".
  
  | MDVREGR 7.1.1.000-TIV-TSMSRV |
  
  
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Operations Center v.7.1.1.000 on all
  supported platforms
  
  
  
  
  Initial Impact:
  Medium
  
  
  
  
  Additional Keywords:
  TSM OC Operations Center  ANRG0092E ANR9999D_2215375891  zz71
  

Local fix

• The Client schedules with indefinite duration are one time
  schedule only so they only runs once.
  Because of this, if these schedules are not used anymore they
  can be deleted.
  Otherwise use the following steps to identify them and change
  "duration" option to a definite interval:
  
  Use the following DB2 select to find the offending schedules.:
  
  db2 "select domainname,schedname,duration,durunits from
  schedules where duration=0"
  
  
  Then for each of those schedules, issue the following Server
  command to change the duration from indefinite to a definite
  days interval:
  
  "update schedule [domainname] [schedname] duration=999
  durunits=days"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This                      *
  * problem is currently projected to be fixed                   *
  * in levels 7.1.1.100 and 7.1.3. Note that this is             *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• 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