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 number
IV63099
Reported component name
TIV WKLD SCHDL
Reported component ID
5698WKB91
Reported release
9S1
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-08-01
Closed date
2014-10-27
Last modified date
2014-10-27
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9S1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
27 October 2014