View previous topic :: View next topic
|
Author |
Message |
Amb
New User
Joined: 12 Mar 2010 Posts: 64 Location: India
|
|
|
|
Can anyone give me a detailed explanation on what is DSNTIAD?
- Is it a utility or a program?
- What are the advantages of using this?
- In the below two cases when do I use PLAN as DSNTIA91 and when do I use plan as DSNTIAD?
Case 1 (PLAN = DSNTIA91)
//RUNTIAD EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAD) PLAN(DSNTIA91) PARMS('RC0') -
LIB('DSN910.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
UPDATE DSN8910.PROJ SET DEPTNO='J01' WHERE DEPTNO='A01';
UPDATE DSN8910.PROJ SET DEPTNO='J02' WHERE DEPTNO='A02';
*/
Case 2 (PLAN = DSNTIAD)
//TSO002 EXEC PGM=IKJEFT01,DYNAMNBR=25,COND=(4,LT)
//STEPLIB DD DISP=SHR,DSN=DB2D.RUNLIB.LOAD
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=Z
//*
//SYSTSIN DD *
DSN SYSTEM (DB2D)
RUN PROGRAM(DSNTIAD) PLAN(DSNTIAD)
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
SET CURRENT SQLID='BN088DBA';
CREATE TABLESPACE SW1XCRA1
IN P0880155
USING STOGROUP G088P01
PRIQTY 40
SECQTY 40
ERASE NO
FREEPAGE 0
PCTFREE 10
BUFFERPOOL BP8
LOCKSIZE ANY
CLOSE YES
SEGSIZE 4
;
COMMIT ;
GRANT USE OF TABLESPACE P0880155.SW1XCRA1 TO BN088SYT;
COMMIT ;
/* |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Quote: |
Is it a utility or a program? |
what are utilities, if not programs?
Here are some pointers to helpful documentation:
Here and here
Quote: |
What are the advantages of using this? |
One of the advantages is that you don't have to write a program for each table you need to access.
Just write the SQL command and run it!
Quote: |
In the below two cases when do I use PLAN as DSNTIA91 and when do I use plan as DSNTIAD? |
You must have 2 different versions of DB2 installed.
DSNTIA91 would run with DB2 v9.1 and DSNTIAD with an older or newer version.
Check with your administrators. Definitely not standard naming convention. |
|
Back to top |
|
|
Amb
New User
Joined: 12 Mar 2010 Posts: 64 Location: India
|
|
|
|
With utility I mean Can I directly execute DSNTIAD as below
//TSO002 EXEC PGM=DSNTIAD
Just as we do DSNUTLIB or IDCAMS.
Why are we having a PLAN for DSNTIAD? |
|
Back to top |
|
|
|