View previous topic :: View next topic
|
Author |
Message |
chan2004
New User
Joined: 28 Mar 2007 Posts: 16 Location: India
|
|
|
|
Hi everyone,
I am a novice in db2.I have some queries.
1)when working with db2,can i see the modified program source module and dbrm?
2)What all does a consistency token contain?
3)when we say compile & link edit the modified source program in jcl,what does that mean?
4)significance of load module or what is it?whenever i see it,its look like a lot of junk values.is there anything that i can understand by looking at it?
5)i have read that whenever an sql statement is encountered in a db2 cobol program,it will search for the particular package.if we use more than one collection and its having the same DBRM,then it will select using the high level qualifier. what i didn't understand is that how can one sql call can relate to more than one package or even more than one dbrm?
I really apreciate if anyone could help me by answeing these ques. |
|
Back to top |
|
|
chan2004
New User
Joined: 28 Mar 2007 Posts: 16 Location: India
|
|
|
|
6)in my bind-db2 jcl,i'm giving like this:
DSN SYSTEM(DSN3)
BIND PACKAGE(BX) -
MEMBER(U987C2L) -
QUALIFIER(BUA) -
OWNER(U142987) -
ACTION(REPLACE) -
VALIDATE(BIND) -
ISOLATION(CS) -
RELEASE(COMMIT) -
CURRENTDATA(NO) -
DEGREE(1) -
EXPLAIN(NO)
END
What does all these signify?
when i'm checking in sysibm.syspacklist to verify whether any entry exists there,
it looks like this,
PLANNAME SEQNO LOCATION COLLID NAME TIMESTAMP
----------------------------------------------------------------------------
XBCDCD 1 * XB * 200454646....
I was thinking to find XB in planname.
Can anyone explain how to corelate the date i've given in the jcl with this table?
If anone can give any extra info also,it would be helpful |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Have you tried the fine manuals?
O. |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
We are sorry to say that only Manuals can give you the brief explanation.
We could help you out with the things provided you have some basic knowledge. Kindly refer to the manuals and revert back to us in case you need furthur clarification. Thank you..! |
|
Back to top |
|
|
|