MVSFORUMS.com

sowzanya · Beginner Joined: 19 Mar 2004 Posts: 4 Topics: 2

What is skct? To which topic is does it really relate to?
_________________
sowjanya

kolusu · Posted: Fri Mar 19, 2004 7:28 am Post subject:

sowzanya,

Please do not shout. Posting in all caps means shouting and please do not open topics with titles as IBM , MVS... I edited this topic title to refer to what you are trying to ask.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kolusu · Posted: Fri Mar 19, 2004 9:39 am Post subject:

Sowzanya,

SKCT(Skeleton Cursor Table) is a portion of the DB2 catalog which reprensts the application plan.Page set SCT02 is used to store skeleton cursor tables (SKCTs). These tables store the access paths to DB2 data. When a plan is executed, DB2 uses this information to access the data it needs.

Because a single SKCT can be longer than the maximum record length that can be used in DB2, SKCTs are stored as a sequence of SKCT sections.

The skeleton cursor table parent record (SCTR) contains as much of the SKCT section as the record can fit. The entire SKCT section is stored in this record if it fits; if it does not fit, it is stored in one or more SCTRs. Each SCTR is identified by a unique section/sequence number.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

sowzanya · Beginner Joined: 19 Mar 2004 Posts: 4 Topics: 2

hi

thanks for the nice explanation. That was really helpful.

thanks
sowjanya
_________________
sowjanya