Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Regarding DSNTIAD

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Regarding DSNTIAD
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: 1228
Location: Israel

PostPosted: Tue Mar 30, 2010 12:42 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Dff between DSNTIAUL and DSNTIAD janmejay All Other Mainframe Topics 1 Fri Oct 31, 2008 11:37 am
No new posts DB2 Abend -818 when using 'DSNTIAD' kalyanp_80 DB2 7 Tue Mar 13, 2007 2:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us