We are running 7.1 FOCUS on MVS in DB2 v7

we just moved to DB2 V7 over the weekend, and are observing the output below on the CREATE. This wasn't occuring prior to the cutover. I'm trying to determine where the BP0 is getting set, because the Ad-hoc user space in DB2 should be using BP10.
The PROFILE in MVS for FOCUS does not contain any parameter to set this.
Can the individual user ID have such a profile and where would I look?

Your help appreciated
Shawn Mahoney

CREATE FILE KANML

(FOC1400) SQLCODE IS -551 (HEX: FFFFFDD9)

(FOC1413) USER HAS INSUFFICIENT AUTHORITY FOR REQUESTED OPERATION

: DSNT408I SQLCODE = -551, ERROR: HOFFE DOES NOT HAVE THE PRIVILEGE TO

: PERFORM OPERATION CREATE INDEX ON OBJECT BP0

: DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE

I can explain what is occurring. You are trying to CREATE a table and chances are in the profile a SQL DB2 SET DBSPACE statement specifies where the table will be created within DB2, however, the INDEX requires another statement:

SQL DB2 SET IXSPACE

Although you do not specifically need to specify which buffer pool to use, it is possible to state which storage group is to be used (storage groups specify a buffer pool):
i.e. SQL DB2 SET IXSPACE USING STOGROUP stgname

Hope that works!

thanks, I'll look into this later today.

I appreciate the help
Shawn Mahoney

Final trick...
I added the parameter BUFFERPOOL BPxx after
the STOGROUP parameter and it worked. I still
don't know what changed in the DB2 upgrade but this will carry us through without much additional work.
Shawn