IO11967: DB2 error SQL0104N might occur when running the icmmrmap job on DB2 Content Manager for z/OS doing replication to DB2 CM on AIX

APAR status

• Closed as program error.

Error description

• Running icmmrmap in a French language enviorment of CM. The LS
  code is generating and expanded exponential field using a ","
  If a DB2 Content Manager resource manager resides in a language
  environment other than English (for example: French), you might
  experience the following error in the job output while running
  batch job icmmrmap to replicate data:
  
  -------+
  DSNT408 I SQLCODE = -104, SQLSTATE = 42601, SYNTAX ERROR OR
  ACCESS RULE VIOLATION FROM DB2 UDB FOR AIX, LINUX, HP-UX, SUN
  AND WINDOWS TOKENS 000000 SOURCELENGTH = 2226,   <set_clause>
  
  The error message in the library server log file will look like
  the following example:
  
  ICMPLSUO UpdateRMObject                   01037 10/07
  12:09:43.449 GMT 2009/10/07 14:09:43.449 LCT ;07120941077211
  5bX1242aef000bX-7e42 USRPLS1 SQL ERROR: SQL0104N Une marque
  inattendue "000000" figure à la suite de "RCELENGTH    = 
  2226,".  Parmi  les marques attendues, on  trouve :
  "<set_clause>".   SQLSTATE=42601
     <SQL0104N Une marque inattendue "000000" figure à la suite de
  "RCELENGTH    =
  2226,".  Parmi  les marques attendues, on  trouve :
  "<set_clause>". 
  SQLSTATE=42601>
     <SQLSTATE 42601: Un caractère, une marque ou une clause est
  incorrect ou absent.>
  ICMPLSUO ICMUPDATERMOBJECT                02127 10/07
  12:09:43.449 GMT 2009/10/07 14:09:43.449 LCT ;07120941077211
  5bX1242aef000bX-7e42 USRPLS1 Exit rc=7015 reason=0 extrc=-104
  extreason=0
  

Local fix

• If possible, run with Decimal=. instead of comma.
  

Problem summary

• In language environments other than English, comma (,) is used
  as the decimal point separator, while a period (.) is used in
  English.  This error occurs when the library server executes an
  SQL statement that updates a column with a decimal point. DB2
  UDB can accept only a period as the decimal point separator.
  The SQL0104 error displays when it encounters a comma as the
  separator.
  

Problem conclusion

• DB2 Content Manager Version 8.4.2 Fix Pack 2 fixes this problem.
  

Temporary fix

• N/A
  

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

  LIBRARY SERVER

• Fixed component ID

  5724B1907

Applicable component levels