PK90582: PROBLEM WITH CREATION OF CONTENT STORE DATABASE ON DB2 RUNNING ON Z/OS

APAR status

• Closed as program error.

Error description

• When trying to set up a content store on db2 on z/OS, the
  following code *should be* generated:
  
  SELECT B.CMID, B.PCMID, C.NAME, C.LOCALEID + (CASE WHEN
  C.ISDEFAULT=0
  THEN
  
  0 ELSE 1 END) +
  
  COALESCE(C.MAPDLOCALEID, 0)*65536, B.CLASSID, '',
  
  (CASE WHEN P.POLICIES IS NULL THEN 0 ELSE 1 END) AS HASSECURITY,
  (CASE
  WHEN (SELECT COUNT(*)
  
  FROM  CMREFORD1 R WHERE R.CMID=B.CMID AND R.PROPID=26) >0 THEN 1
  ELSE 0
  END), B.DISABLED,
  
  CASE B.CLASSID WHEN 39 THEN (SELECT SCHED.TASKID FROM
  CMOBJPROPS2 SCHED
  WHERE SCHED.CMID=B.CMID)
  
  WHEN 111 THEN (P11.EVENTID) ELSE COALESCE((SELECT P2.OBJID FROM
  
  CMOBJPROPS1 P2
  
  WHERE P2.CMID=B.CMID), D.DISPATCHERPATH) END,
  
  (CASE WHEN (SELECT COUNT(*)  FROM CMREFNOORD1 D1 WHERE
  D1.CMID=B.CMID
  AND
  
  D1.PROPID=9) >0 THEN 1 ELSE 0 END)
  
  AS HASCREDNAMESPACES, (CASE WHEN P2.OLOCALEID IS NULL THEN 0
  
  ELSE P2.OLOCALEID + 65536 * COALESCE(L.MAPDLOCALEID,0) END),
  
  COALESCE(P2.FORMAT, 15), (CASE WHEN DEPLOY.MESSAGE IS NULL THEN
  0 ELSE 1
  END), DEPLOY.DEPLOYOBJUSAGE,
  
  (CASE WHEN BO.RECIPSEMAIL IS NULL THEN 0 ELSE 1 END),
  SID.STOREID,
  OWNER.REFCMID
  
  FROM CMOBJECTS B LEFT OUTER JOIN CMOBJPROPS6 D ON B.CMID=D.CMID
  LEFT
  OUTER
  
  JOIN
  
  CMOBJPROPS11 P11 ON B.CMID=P11.CMID LEFT OUTER JOIN CMOBJPROPS54
  P2 ON
  B.CMID=P2.CMID LEFT OUTER JOIN CMOBJPROPS25 DEPLOY ON
  B.CMID=DEPLOY.CMID
  LEFT OUTER JOIN
  
  CMLOCALES L ON L.LOCALEID=P2.OLOCALEID LEFT OUTER JOIN
  CMOBJPROPS14 BO
  ON BO.CMID=B.CMID LEFT OUTER JOIN CMSTOREIDS SID ON
  SID.CMID=B.CMID LEFT
  OUTER JOIN
  
  CMREFNOORD2 OWNER ON OWNER.CMID=B.CMID, CMPOLICIES P, CMOBJNAMES
  C WHERE
  B.CMID=P.CMID
  
  AND B.CMID=C.CMID
  
  ORDER BY B.CMID
  
  Instead of this (which would work), when using UTF-8 or anything
  else than an English locale on the db, the coalesque function
  produces a ",0" (without space between the comma and the zero),
  and so the database instance cannot be created.
  

Local fix

• Temporary fix would be to use an English locale
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Fix Pack 1  *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG8 BI DATA MG

• Fixed component ID

  5724W12DM

Applicable component levels