Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error when writing CREATE in DB2
Go
New
Search
Notify
Tools
Reply
  
Error when writing CREATE in DB2
 Login/Join
 
Member
posted
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
 
Posts: 6 | Location: Grand Rapids, MI | Registered: April 25, 2003Reply With QuoteReport This Post
<Claudia Holanda>
posted
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!
 
Reply With QuoteReport This Post
Member
posted Hide Post
thanks, I'll look into this later today.

I appreciate the help
Shawn Mahoney
 
Posts: 6 | Location: Grand Rapids, MI | Registered: April 25, 2003Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 6 | Location: Grand Rapids, MI | Registered: April 25, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error when writing CREATE in DB2

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.