| View previous topic :: View next topic |
| Author |
Message |
matt9go
Beginner
Joined: 17 Dec 2007
Posts: 2
Topics: 1
Location: Pennsylvania
|
 Posted: Wed Mar 25, 2009 10:47 am Post subject: DB2 Plan Name Length |
 |
|
It is my understanding that with DB2 V8, the Plan Name Length has changed from a max of 8 to a max of 24.
When I try to Bind a Plan with a length of 9, I get the error shown below.
Please tell me what I need to do to allow a longer Plan Name.
Thanks...
DSN SYSTEM(DSY1)
DSN
BIND PLAN (SR55TSXGF) OWNER(DEVOWN) PKLIST(SR55_BATCH.*) VALIDATE(RUN)
CURRENTDATA(NO) DEGREE(1) RETAIN
IKJ56702I INVALID PLAN IDENTIFIER, SR55TSXGF
IKJ56701I MISSING PLAN NAME:+
IKJ56701I MISSING 1 ALPHABETIC + UP TO 7 ALPHANUM/NATIONAL CHARS
DSN
END |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Wed Mar 25, 2009 12:23 pm Post subject: |
|
|
| matt9go wrote: | | It is my understanding that with DB2 V8, the Plan Name Length has changed from a max of 8 to a max of 24. |
matt9go,
I am not sure as to where you got that info but the z/OS DB2 only supports 8 bytes. Check this link
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQJ12/A.0?
The last but one entry in the first table in that link tells that plan name is still 8 bytes.
Kolusu |
|
| Back to top |
|
|
matt9go
Beginner
Joined: 17 Dec 2007
Posts: 2
Topics: 1
Location: Pennsylvania
|
| Posted: Thu Mar 26, 2009 7:23 am Post subject: I am refering to PLAN name |
|
|
Maybe my initial post was not clear...
I am trying to Bind a PLAN (mentioned six times in my post).
The information you provided is for a Package (never mention in my post).
If you look at the SYSIBM.SYSPLAN table: | Code: |
Cmd F == Table: SYSIBM.SYSPLAN(T1) ================
NAME CREATOR
--------VCH(24)--------- =========VCH(128)===
or the SYSIBM.SYSPACKLIST table:
Cmd F == Table: SYSIBM.SYSPACKLIST(T1) =====
PLANNAME SEQNO
--------VCH(24)--------- -SMALLINT- ==
|
You see the the field is vch(24). This is where my information comes from.
I appreciate any help you can provide. |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Thu Mar 26, 2009 7:50 am Post subject: |
|
|
matt9go,
refer back to kolusu's link. the item above package name:
| Quote: | Name of buffer pool name, catalog,
database, plan, program, tablespace |
all are 8 bytes.
the attributes of a column should not be construed as the definition of the value contained. the only information you obtained is the attributes of the column.
from there you made an false assumption.
you were so ready to defend your error, you missed the answer.
| Quote: | | I appreciate any help you can provide. |
i imagine this is embarrassing for you, considering you must change your plan name (and possibly everyone else who followed your advice).
suggest you stop making assumptions, and look for hard coded definitions. I realize that finding things in the manuals can be a real pain, but the pain incurred when one researches is less than the pain of making errors.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Mar 26, 2009 10:00 am Post subject: |
|
|
| matt9go wrote: | | The information you provided is for a Package (never mention in my post). |
matt9go,
Woah. You seem to have trouble following directions. And your assumption about the planname being 24 bytes is from the column attributes of catalog tables? 
Kolusu |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Thu Mar 26, 2009 10:11 am Post subject: |
|
|
by the way
| Quote: | | I am trying to Bind a PLAN (mentioned six times in my post). |
actually 7 times (also in the title)
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
