JR34503: QAPPLY GETS ASN7512E RC6 WHEN ACTIVATING A SUBSCRIPTION THAT HAS AN EXPRESSION CONTAINING : ( COLON ) AS PART OF ITS DATA VALUE

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Example of Expression used -
  
  case when :COL2 = '10:30:12' then '10:00:00' else :COL2 end
  
  Where COL2 is a column name and '10:30:12' is a data value.
  
  Qapply log shows the following error messages when the
  subscription is capstarted -
  
  
  
  2009-10-08-12.05.04.437000 <browser::verifyMsgVersion> ASN8999D
  "Q Apply" : "QASN" : "BR00000" : Browser for queue
  'QASN.SOURCE2TARGET.RECVQ' received a 'ASNMQ_SUBSCHEMA_MSG'
  message.
  2009-10-08-12.05.04.437000 <QAsubMgr::add2SrcColMap> ASN8999D
  "Q Apply" : "QASN" : "BR00000" : RC=606: Colname '3012'' not
  found in SCHEMA msg.
  2009-10-08-12.05.04.437000 <QAsubMgr::generateSrcColMap>
  ASN0589I  "Q Apply" : "QASN" : "BR00000" The program received an
  unexpected return code "606" from routine
  "QAsubMgr::add2SrcColMap".
  2009-10-08-12.05.04.437000 <QAsubMgr::verifyTrgCols> ASN0589I
  "Q Apply" : "QASN" : "BR00000" The program received an
  unexpected return code "606" from routine
  "QAsubMgr::generateSrcColMap".
  2009-10-08-12.05.04.437000 <QAsubMgr::verifyTrgCols> ASN8999D
  "Q Apply" : "QASN" : "BR00000" : The source column 'case when
  :COL2 = '10:30:12' then '10:00:00' else :COL2 end' of Q
  subscription 'EXP10001' was specified in IBMQREP_TRG_COLS table
  but did not match a subscribed source column in IBMQREP_SRC_COLS
  table.
  2009-10-08-12.05.04.437000 <QAsubMgr::issueSchemaErrorMsg>
  ASN7512E  "Q Apply" : "QASN" : "BR00000" : The Q Apply program
  could not activate the Q subscription "EXP10001" (receive queue
  "QASN.SOURCE2TARGET.RECVQ", replication queue map
  "SOURCE_QASN_TO_TARGET_QASN").  Reason code: "6".
  
  
  QApply should not treat ':' to be the beginning of a column name
  if it is part of a sub string enclosed in single/double quotes
  

Local fix

• none
  If possible try not to use : colon as part of data value.
  

Problem summary

• Subscriptions with column SQL expressions using
  data values that contain colon characters (such as
  date/timestamp values) fail to get activated due to incorrect
  parsing of the SQL expression in QAPPLY.
  

Problem conclusion

• QAPPLY will now correctly parse colon
  characters occurring within single quotes as part of data
  values/literals.  Only colons not enclosed within single
  quotes will be treated as markers for column names.
  

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

  REPLICATION SER

• Fixed component ID

  5724N9800

Applicable component levels

• R950 PSY

     UP