By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Weird - Uncommanded schema change in mid script

P: n/a
I'm running a script from the PC Command Center to a z/OS DB2 at
v8.1.5. In mid script, the schema changes, despite my setting it
explicitly at the start of the script.

Does anyone know what might cause this?

Here's a snip from the script output -

SELECT CURRENT SQLID, CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1
--------
--------------------------------------------------------------------------------------------------------------------------------
GOODDATA
GOODDATA
1 record(s) selected.

CREATE TABLE WFM_GRAPH_TYPE ( GRAPH_TYPE_ID DECIMAL(15, 0) NOT
NULL) IN DATABASE GOODDATA
DB20000I The SQL command completed successfully.

CREATE UNIQUE INDEX GRAPH_TYPE14PK ON WFM_GRAPH_TYPE
( GRAPH_TYPE_ID ASC ) CLUSTER
DB20000I The SQL command completed successfully.

CREATE UNIQUE INDEX GRAPH_TYPE14AK1 ON WFM_GRAPH_TYPE
( SYSTEM_ID ASC, GRAPH_TYPE_C
ASC )
DB20000I The SQL command completed successfully.

CREATE INDEX GRAPH_TYPE14IF1 ON WFM_GRAPH_TYPE
( SYSTEM_ID ASC )
DB20000I The SQL command completed successfully.

ALTER TABLE WFM_GRAPH_TYPE ADD PRIMARY KEY (GRAPH_TYPE_ID)
DB20000I The SQL command completed successfully.

DROP TABLE WFM_WKLOAD_GROUP_L
DB20000I The SQL command completed successfully.

COMMIT
DB20000I The SQL command completed successfully.

SELECT CURRENT SQLID, CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1
--------
--------------------------------------------------------------------------------------------------------------------------------
GOODDATA
BADDATA
1 record(s) selected.

Why would it change the current schema on the fly?

Regards,
MVSGuy

Oct 24 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.