[z/OS] IBM provided Stored Procedures

Jorge Martelanz

[z/OS] IBM provided Stored Procedures
In Redbook "DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond", they say that the stored procedures originally shipped as part of the "DB2 Management Clients Package's z/OS Enablement", are now included in the DB2 base. They also say that the procedures were renamed. For example, DSNACCTS is replaced by ADMIN_COMMAND_DSN
My questions are: Do we need the old ones? The Control Center will use the old or the new ones?
In SDSNSAMP for DB2 9, job DSNTIJCC that creates the "old" procedures is still there, but it is not mentioned at all in the Installation manual. I hope somebody can point me to a paper that clarifies this issue. Thanks and Happy New Year. Jorge

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roger Miller

Re: [z/OS] IBM provided Stored Procedures
(in response to Jorge Martelanz)
The primary information is in the Information Center.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.inst/db2z_enabledb2supplstprocs.htm#db2z_enabledb2supplstprocs
You can find more information in the APARs which deliver the procedures. For example,
http://www.ibm.com/support/docview.wss?uid=swg1PK45599

In some situations you do need the old procedures. These routines have many different
users, and getting all of them changed over to the new ones generally takes a long time.

You asked ...

In Redbook "DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond", they say that the stored procedures originally shipped as part of the "DB2 Management Clients Package's z/OS Enablement", are now included in the DB2 base. They also say that the procedures were renamed. For example, DSNACCTS is replaced by ADMIN_COMMAND_DSN
My questions are: Do we need the old ones? The Control Center will use the old or the new ones?
In SDSNSAMP for DB2 9, job DSNTIJCC that creates the "old" procedures is still there, but it is not mentioned at all in the Installation manual. I hope somebody can point me to a paper that clarifies this issue. Thanks and Happy New Year. Jorge

Roger Miller

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv