PK78381: THE EVENT DATABASE IS NOT GETTTING CREATED FOR DB2 ON Z/OS

Fixes are available

APAR status

Closed as program error.

Error description

I have installed Base 7003 on ezwas zos machine
Product Directory        /WebSphere/Base/AppServer
Version Directory
/WebSphere/Base/AppServer/properties/version
DTD Directory
/WebSphere/Base/AppServer/properties/version/dtd
Log Directory            /WebSphere/Base/AppServer/logs
TMP Directory            /tmp

Product List
------------------------------------------------------------
ND                       installed

Installed Product
------------------------------------------------------------
Name                     IBM WebSphere Application Server for
z/OS
Version                  7.0.0.3
ID                       ND
Build Level              cf030849.25
Build Date               12/10/08
Architecture             System z


I was configuring the CEI using the document
http://rtpgsa.ibm.com/projects/w/was6lqa/vekumari/
FP7003/zos_CEIBASE/Configure%20DB2%20on%20the%20z.doc

After I ran the converttoDataset.sh from the dbscripts created.

I tried the SQL proccessing using SPUFI that is given in the
document for CEI(CRDDL1)
I was seeing these errors

********************************* Top of Data **************
---------+---------+---------+---------+---------+---------+
------------------------------------------------------------

-- Licensed Materials-Property of IBM

-- (C)Copyright IBM Corp 2004

-- All rights reserved

-- US Government Users Restricted Rights

-- Use, duplication, or disclosure restricted

-- by GSA ADP Schedule Contract with IBM Corp

------------------------------------------------------------



-- tablespace for static configuration tables. Only a small
amount
-- of data is loaded into the tables when the CEI application
is
-- installed and the values are static. Since the values are
static,
-- the FREEPAGE and PCTFREE values are set to 0.

-- Three rows of cei_t_cbe_map table fit per 4K page while
only one
-- row of the cei_t_properties table fit per page.

CREATE TABLESPACE CEICFG

  IN event

  USING STOGROUP sysdeflt

  PRIQTY 50

  SECQTY 5

  FREEPAGE 0

  PCTFREE 0

  BUFFERPOOL BP9

  LOCKSIZE PAGE

  COMPRESS YES

  CCSID UNICODE;

---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -204, ERROR:  EVENT IS AN UNDEFINED NAME

DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE

DSNT415I SQLERRP    = DSNXISUB SQL PROCEDURE DETECTING ERROR

DSNT416I SQLERRD    = 25 0  0  -1  0  0 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD    = X'00000019'  X'00000000'  X'00000000'
X'FFFFFFFF'
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION

---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0

 Command ===>
Scroll ===> PAGE


The event database is not gettting created using these
scripts.

When i tried to manually run the cr_event_db2zos.sh using the
USER61 and kri1shna. it does not work.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  All users of WebSphere Application Server   *
*                  V7.0 for z/OS Common Event Infrastructure   *
*                  that configures it to use DB2 z/OS          *
*                  database as repository for the events.      *
****************************************************************
* PROBLEM DESCRIPTION: When the user performs the              *
*                      configuration of Common Event           *
*                      Infrastructure to use the DB2 z/OS      *
*                      database the process consists in two    *
*                      phases. First step is to execute the    *
*                      configuration AdminTask and the         *
*                      second one is to execute the            *
*                      generated database configuration        *
*                      scripts via zOS DataSet tools. The      *
*                      last step fails due to the fact         *
*                      that the database is not created. The   *
*                      converted DataSet does not execute      *
*                      the database creation step.             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The execution of the serialized DataSet containing the
database objects creation/configuration scripts fails at
the step of tablespaces creation step:
DSNT408I SQLCODE = -204, ERROR:  EVENT IS AN UNDEFINED NAME

DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE

DSNT415I SQLERRP    = DSNXISUB SQL PROCEDURE DETECTING ERROR

DSNT416I SQLERRD    = 25 0  0  -1  0  0 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD    = X'00000019'  X'00000000'  X'00000000'
X'FFFFFFFF'
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
This is due to the fact that the database creation is not
performed at a previous step as it should be.

Problem conclusion

The database/database objects creation scripts were corrected
by separating the database creation step from the tablespaces
creation step and the code responsible with database creation
has been changed in order to comply with the scripts modified
content.

APAR PK78381 is currently targeted for inclusion in Service
Level (Fix Pack) 7.0.0.3 of WebSphere Application Server V7.0
for z/OS.

Please refer to URL:
//www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
for Fix Pack availability.

Temporary fix

Comments

APAR Information

APAR number
PK78381
Reported component name
WEBSPHERE FOR Z
Reported component ID
5655I3500
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-09
Closed date
2009-01-27
Last modified date
2009-05-03

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

PK80280

Fix information

Fixed component name
WEBSPHERE FOR Z
Fixed component ID
5655I3500

Applicable component levels

R700 PSY UK45120
UP09/04/06 P F904

Fix is available

Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"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":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 December 2021

Tips

PK78381: THE EVENT DATABASE IS NOT GETTTING CREATED FOR DB2 ON Z/OS

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

R700 PSY UK45120

Fix is available

Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

Document Information

Share your feedback

Need support?