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 fixProblem summary
correct. The updates from the submittor text have been made
to the release notes. Problem conclusionTemporary fixComments
APAR information | APAR number | PQ47859 | Reported component name | WAS ADVANCED AI | Reported component ID | 5648C8400 | Reported release | 350 | Status | CLOSED DOC | PE | NoPE | HIPER | NoHIPER | Submitted date | 2001-04-12 | Closed date | 2001-05-14 | Last modified date | 2001-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 APAR is sysrouted TO one or more of the following:Modules/Macros
Applicable component levels |
|