PM87549: FFDCS FOR SQLCODE=-551 AT APP SERVER STARTUP

Fixes are available

APAR status

Closed as program error.

Error description

At server startup, the App Server logs a FFDC.  FFDC file
contents are

1/30/13 14:58:36:115 GMT]     FFDC
Exception:com.ibm.db2.jcc.am.SqlSyntaxErrorException
SourceId:com.ibm.ws.scheduler.TaskStoreImplDB2.fixMissingConstra
int
ProbeId:113
Reporter:com.ibm.ws.scheduler.TaskStoreImplDB2@7dcadc00
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-551,
SQLSTATE=42501, SQLERRMC=DWIINTRU;ALTER
TABLE;DWI4RLSE.WPS_SCDTREG,
DRIVER=4.13.136
.
  at com.ibm.db2.jcc.am.id.a(id.java:677)
  at com.ibm.db2.jcc.am.id.a(id.java:60)
  at com.ibm.db2.jcc.am.id.a(id.java:127)
  at com.ibm.db2.jcc.am.no.c(no.java:2653)
  at com.ibm.db2.jcc.am.no.d(no.java:2641)
  at com.ibm.db2.jcc.am.no.b(no.java:2027)
  at com.ibm.db2.jcc.t4.cb.i(cb.java:225)
  at com.ibm.db2.jcc.t4.cb.c(cb.java:48)
  at com.ibm.db2.jcc.t4.q.b(q.java:38)
  at com.ibm.db2.jcc.t4.sb.h(sb.java:114)
  at com.ibm.db2.jcc.am.no.hb(no.java:2022)
  at com.ibm.db2.jcc.am.no.a(no.java:3166)
  at com.ibm.db2.jcc.am.no.c(no.java:733)
  at com.ibm.db2.jcc.am.no.executeUpdate(no.java:717)
  at
  com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteUpdate
(WSJdb cStatement.java:1799)
  at
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate
(WSJdbcSt atement.java:1130)
  at
com.ibm.ws.scheduler.TaskStoreImplDB2.fixMissingConstraint
(TaskS toreImplDB2.java:98)
  at
  com.ibm.ws.scheduler.SchedulerImpl.initialize
(SchedulerImpl.java :477)
  at
  com.ibm.ws.scheduler.SchedulerImpl.access$000
(SchedulerImpl.java :186)
  at com.ibm.ws.scheduler.SchedulerImpl$8.run
(SchedulerImpl.java:2355 )
  at
  java.security.AccessController.doPrivileged
(AccessController.jav a:280)
  at
  com.ibm.ws.scheduler.SchedulerImpl.findByName
(SchedulerImpl.java :2333)
  at
  com.ibm.ws.scheduler.SchedulerImpl.findByName
(SchedulerImpl.java :2317)
  at
  com.ibm.ws.scheduler.SchedulerImpl.findTasksByName
(SchedulerImpl .java:
  2280)
     ...

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server V8.0 and V8.5                        *
****************************************************************
* PROBLEM DESCRIPTION: FFDC with exception                     *
*                      com.ibm.db2.jcc.am.SqlSyntaxErrorExcept *
*                      io                                      *
*                      n thrown during server startup on z/OS  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
FFDC with exception com.ibm.db2.jcc.am.SqlSyntaxErrorException
SourceId:com.ibm.ws.scheduler.TaskStoreImplDB2.fixMissingConstra
int thrown during server startup on z/OS.
Altering the table for fixing the missing contraint is only
applicable for DB2 on distributed and DB2 iSeries, hence
exception is thrown when it is executed with DB2 on z/OS

Problem conclusion

A conditional check has been added to check the database
version  and ALTER TABLE command is not executed when the
database used is DB2 on z/OS

APAR PM87549 is currently targeted for inclusion in
Fix Packs 8.0.0.8 and 8.5.5.1 of WebSphere Application
Server.

Please refer to the Recommended Updates page for delivery
information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

In addition, please refer to URL:
http://www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
for Fix Pack PTF information.

Temporary fix

Comments

APAR Information

APAR number
PM87549
Reported component name
WEBSPHERE FOR Z
Reported component ID
5655I3500
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-22
Closed date
2013-07-22
Last modified date
2013-07-22

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
WEBSPHERE FOR Z
Fixed component ID
5655I3500

Applicable component levels

R800 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"800","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
11 January 2022

Tips

PM87549: FFDCS FOR SQLCODE=-551 AT APP SERVER STARTUP

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

R800 PSY

Document Information

Share your feedback

Need support?