Page 1 of 1

Plan and Package for New DB2

PostPosted: Fri Jun 17, 2011 10:33 am
by jaggz
Hi,

We have installed a new db2 subsystem in our shop. Could anyone suggest me or direct me the way to create a package and Plan , so that we can try do a bindpack and bindplan. I tried looking at the DB2 Admin guide but I was not able fetch any details about creating a plan and package . This is required for our sandbox system where we can tryout out some minimal db2 dba admin activities.

Regards,
jaggz

Re: Plan and Package for New DB2

PostPosted: Fri Jun 17, 2011 12:32 pm
by GuyC
I'm sure that, during installation , some binding has taken place.
What "minimal db2 dba admin activities" would you try out if you don't know how to bind?

Re: Plan and Package for New DB2

PostPosted: Sat Jun 18, 2011 7:49 am
by jaggz
Hi Guy,

I am just trying to trace the Resource code for compilation, so that i can create a load module and a DBRM. Then i can Use Bind command to DBRM to db2 as Plan or package. Yes during installation there were some Bind steps.


Regards,
Jags

Re: Plan and Package for New DB2

PostPosted: Mon Jun 20, 2011 1:36 pm
by GuyC
jaggz wrote:trace the Resource code for compilation
I have no idea what that means.

Re: Plan and Package for New DB2

PostPosted: Wed Jun 22, 2011 4:14 pm
by jaggz
GuyC,

Is it possible to view the contents any plan listed under : sysibm.sysplans ?

Re: Plan and Package for New DB2

PostPosted: Wed Jun 22, 2011 4:27 pm
by jaggz
Where does the sysibm.sysplans plan are getting stored ? Is it possible to view those contents ?

Re: Plan and Package for New DB2

PostPosted: Wed Jun 22, 2011 8:56 pm
by GuyC
name => sysibm.sysplan => planname => sysibm.syspacklist => location,COLLID, NAME => sysibm.syspackage