IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Regarding DSNTIAD


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 30, 2010 11:33 am
Reply with quote

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
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Tue Mar 30, 2010 12:42 pm
Reply with quote

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
View user's profile Send private message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 30, 2010 7:31 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Dff between DSNTIAUL and DSNTIAD All Other Mainframe Topics 1
No new posts DB2 Abend -818 when using 'DSNTIAD' DB2 7
Search our Forums:

Back to Top