IV61984: In TADDM 7.2.1.6 verify-data tool can fail with the error: com.ibm.db2.jcc.am.SqlSyntaxErrorException

APAR status

• Closed as program error.

Error description

• In verify-tool log you can find:
  generator.DuplicatesVerificationGenerator - Executing sql:
  select DOMNAMCT.guid_x, DOMNAMCT.displayname_x,
  DOMNAMCT.jdoclassx, DOMNAMCT.lastmodifiedtime_x,
  DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X,
  DOMNAMCT.CONTEXTNO_X from DOMNAMCT where DOMNAMCT.deleted_x = 0
  and (concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X
  , 'a')),
  concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a'))) in (select
  concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X ,
  'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) from
  DOMNAMCT where DOMNAMCT.deleted_x = 0 and jdoclassx in
  ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte
  xtJdo') and DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X is not null
  and DOMNAMCT.CONTEXTNO_X is not null group by concat('a',
  concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')),
  concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) having
  count(guid_x) > 1) and DOMNAMCT.jdoclassx in
  ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte
  xtJdo') ORDER BY 5, 6, 4 DESC
  2014-06-24 01:01:19,790 [main] DEBUG
  generator.DuplicatesVerificationGenerator -
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-440,
  SQLSTATE=42884, SQLERRMC=CONCAT;FUNCTION, DRIVER=3.63.75
  at com.ibm.db2.jcc.am.fd.a(fd.java:679)
  

Local fix

Problem summary

• In verify-tool log you can find:
  generator.DuplicatesVerificationGenerator - Executing sql:
  select DOMNAMCT.guid_x, DOMNAMCT.displayname_x,
  DOMNAMCT.jdoclassx, DOMNAMCT.lastmodifiedtime_x,
  DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X,
  DOMNAMCT.CONTEXTNO_X from DOMNAMCT where DOMNAMCT.deleted_x = 0
  and (concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X
  , 'a')),
  concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a'))) in (select
  concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X ,
  'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) from
  DOMNAMCT where DOMNAMCT.deleted_x = 0 and jdoclassx in
  ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte
  xtJdo') and DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X is not null
  and DOMNAMCT.CONTEXTNO_X is not null group by concat('a',
  concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')),
  concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) having
  count(guid_x) > 1) and DOMNAMCT.jdoclassx in
  ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte
  xtJdo') ORDER BY 5, 6, 4 DESC
  2014-06-24 01:01:19,790 [main] DEBUG
  generator.DuplicatesVerificationGenerator -
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-440,
  SQLSTATE=42884, SQLERRMC=CONCAT;FUNCTION, DRIVER=3.63.75
  at com.ibm.db2.jcc.am.fd.a(fd.java:679)
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
  | Fix Pack | 7.2.1-TIV-ITADDM-FP0007
  | Fix Pack | 7.2.2-TIV-ITADDM-FP0003
  Check the IBM Software Support web site for availability of the
  above maintenance packages.
  

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

  APP DEPENDENCY

• Fixed component ID

  5724N5500

Applicable component levels

• R721 PSY

     UP