IV63099: TWS DYNAMIC AGENT FAILS TO START WITH MORE THAN 99 CPU

APAR status

• Closed as program error.

Error description

• TWS dynamic agent with more than 99 CPUs would not start.
  
  The problem applies to all TWS versions up till now.
  
  The JobManager log showed >>>>
  
  AWSITA082E The agent got an error response while sending
  the resource information to the server. The error code is
  "RDBMS_TRANSPORT_PROBLEM" and the error message is
  "AWKJDB801E An internal error has been found while
  accessing the database. The internal error message
  is: "[jcc][t4][1037][11190][3.65.110] Exception
  occurred during BigDecimal conversion.  See attached
  Throwable for details. ERRORCODE=-4220,
  SQLSTATE=null".".
  
  The root cause for the problem is that the column
  which holds the number of CPUs can only contain 2 digits.
  
  See :-
  
  $ db2 describe table DWB.CSR_COMPUTER_SYSTEM_RESOURCES
  | grep CSR_PROC_NUM
  

Local fix

• In order to fix the problem, the following workaround
  can be done
  
  db2 'alter table DWB.CSR_COMPUTER_SYSTEM_RESOURCES
  alter column CSR_PROC_NUM set data type DECIMAL(4)'
  
  db2 'reorg table DWB.CSR_COMPUTER_SYSTEM_RESOURCES'
  

Problem summary

• The problem is that the column which holds the number
  of machine CPUs can only contain 2 digits.
  
  $ db2 describe table DWB.CSR_COMPUTER_SYSTEM_RESOURCES
  | grep CSR_PROC_NUM
  
  If the system where the agent is running contains
  more than 99 cpu the value cannot be stored and the
  dynamic agent doesn't start.
  

Problem conclusion

• The apar will be fixed in next TWS release
  

Temporary fix

• See local 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

  TIV WKLD SCHDL

• Fixed component ID

  5698WKB91

Applicable component levels

• R9S1 PSY

     UP