PQ47859: DB2390.SQL FILE DOES NOT RUN AS SHIPPED.


APAR

APAR status
Closed as documentation error.

Error description
The db2390.sql sample supplied with 3.5.3 in incomplete. As
supplied, the DB2 colums of type ROWID require the NOT NULL
keyword which is not supplied. to correct the syntax, the
following change command will correct this.
C'ROWID GENERATED''ROWID NOT NULL GENERATED' all
Further, the Add INCBEANTBL  step requires a table definition
which is missing from the supplied JCL. The following changes to
include this table definition is necessary to avoid errors when
starting the Default Server.
Add to the IDCAMS DELETE portion of the documentation:
        DELETE hlq DSNDBC.wasdb.INCBNTS.I0001.A001
Add to the IDCAMS cluster definitions:Add to the IDCAMS DELETE portion of the documentation:DELETE hlq DSNDBC.wasdb.INCBNTS.I0001.A001
DEFINE CLUSTER - (NAME(hlq.DSNDBC.wasdb.INCBNT:I0001.A001) LINEAR REUSE VOLUMES(tgtVolume) RECORDS(100 50) SHAREOPTIONS(3 3) ) DATA (NAME(hlq.DSNDBD.wasdb.INCBNTS.I0001.A001) ) Add DDL to create the objects CREATE TAVLESPACE INCBNTS IN wasdb BUFFERPOOL BP0 -- the bufferpool will be changed in a later LOCKSIZE ROW SEGSIZE 32 USING VCAT hlq PCTFREE 15; CREATE TABLE EJB.INCBEANTBL( PRIMARYKEY VARCHAR(50) NOT NULL, THEVALUE INTEGER WITH DEFAULT), PRIMARY KEY (PRIMARYKEY)) in wasdb.INCBNTS From OEDIT issue a change all command for the following text occurrances with the JCL tgtvolume - target volume for dataset allocation hlq - High Level Qualigfier used for DB2 user datasets wasdb - the name of the DB2 database you wish to create for the administrative repository DBXX - the name of the DB2 subsystem BP0 - Contact your system administrator for the proper DB2 buffer pool, it will likely not be BP0 In some environments, a JOBLIB card will need to be added for the SDSNLOAD library. Here is an example:Add to the IDCAMS cluster definitions:DEFINE CLUSTER -(NAME(hlq.DSNDBC.wasdb.INCBNT:I0001.A001)LINEARREUSEVOLUMES(tgtVolume)RECORDS(100 50)SHAREOPTIONS(3 3) )DATA(NAME(hlq.DSNDBD.wasdb.INCBNTS.I0001.A001) )Add DDL to create the objectsCREATE TAVLESPACE INCBNTS IN wasdbBUFFERPOOL BP0 -- the bufferpool will be changed in a laterLOCKSIZE ROWSEGSIZE 32USING VCAT hlqPCTFREE 15;CREATE TABLE EJB.INCBEANTBL(PRIMARYKEY VARCHAR(50) NOT NULL,THEVALUE INTEGER WITH DEFAULT),PRIMARY KEY (PRIMARYKEY)) in wasdb.INCBNTSFrom OEDIT issue a change all command for the following textoccurrances with the JCLtgtvolume - target volume for dataset allocationhlq - High Level Qualigfier used for DB2 user datasetswasdb - the name of the DB2 database you wish to create forthe administrative repositoryDBXX - the name of the DB2 subsystemBP0 - Contact your system administrator for the properDB2 buffer pool, it will likely not be BP0In some environments, a JOBLIB card will need to be added for
//JOBLIB DD DSN=DBV.SDSNLOAD,DISP=SHR Add a GRANT statement for the newly create EJB.INCBEANTBL object GRANT DELETE,INSERT,SELECT,UPDATE ON TABLE EJB.INCBEANTBL TO PUBLIC AT ALL LOCATIONS; The included JCL grants access to the objects to PUBLIC. Instead, consider granting access only to the userids used by WebSphere. This will help users implement S390 access through our samples.
the SDSNLOAD library. Here is an example://JOBLIB DD DSN=DBV.SDSNLOAD,DISP=SHRAdd a GRANT statement for the newly create EJB.INCBEANTBL objectGRANT DELETE,INSERT,SELECT,UPDATEON TABLE EJB.INCBEANTBLTO PUBLIC AT ALL LOCATIONS;The included JCL grants access to the objects to PUBLIC.Instead, consider granting access only to the userids used byWebSphere.This will help users implement S390 access through our samples.
Local fix
Problem summary
correct.  The updates from the submittor text have been made
to the release notes.
Problem conclusion
Temporary fix
Comments
APAR information
APAR numberPQ47859
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED DOC
PENoPE
HIPERNoHIPER
Submitted date2001-04-12
Closed date2001-05-14
Last modified date2001-05-14

APAR is sysrouted FROM one or more of the following:

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


Modules/Macros

Fix information
APAR is sysrouted TO one or more of the following:Modules/Macros

Applicable component levels











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ47859
IBM Group: Software Group
Modified date: 2001-05-14