MVSFORUMS.com

gans79 · Beginner Joined: 31 Aug 2005 Posts: 51 Topics: 27

hi,
I need to perform DB2 load & Unload ,
I went through the forum, i found out that we could use the below
utilities
1. to unload - DSNTIAUL
2. to load - DSNUTILB
but i'am not clear on the different options that can be set,
can anyone explain with example about the different options.

thanks
ganesh

kolusu · Posted: Tue Oct 11, 2005 4:35 am Post subject:

gans79,

Check this link for a detailed explanation with examples of DSNTIAUL

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542

check this link for loading the table from a flat file

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.12?DT=20020826194002

Hope this helps...

cheers

kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

shekar123 · Posted: Wed Oct 12, 2005 1:23 am Post subject: db2 load / unload

Hai Kolusu,

I have a query regarding the links provided by you in this case / any other answers you give as links to the solutions.
When i give the link in the browser http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/books/ and i get the display like

Shelf: BookManager

Find books with titles, names, or doc numbers containing:

--------------------------------------------------------------------------------

Book Title Name Date Document

IBM BookManager BookServer Demonstration Book xwebdemo 04/23/97 18:25:24 XWEBDEMO

Library Server for z/OS: Getting Started ephx2l00 08/25/03 14:22:59 SC31-6376-00

Total books = 2

Total books not cataloged = 0

Path = /usr/lpp/internet/server_root/bookmgr_OS390/bookmgr

For example you have given the link for answering DSNTIAUL:
--------------------------------------------------------------

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542

My question is how do i know which book to refer like DSNAPH11 after going to the

URL http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/books/ ? Is there any means where in i can know the books available or can u please tell me how do i go about it for searching any other topic / book name related to Mainframe Technology ?

kolusu · Posted: Wed Oct 12, 2005 4:26 am Post subject:

Shekhar123,

Browsing books thru bookmanager can be a bit over whelming. But you can narrow your search by subject.

I will explain briefly .Now go to this link

http://publib.boulder.ibm.com/cgi-bin/bookmgr/LIBRARY

Since the question asked here deals with DB2 unload and load we can filter out the books just for DB2.

In the above link just type DB2 and click on FIND.

You will get all the manuals related to DB2. Now within these we need to sort out the books that we want.

Most of the time you will need the following manuals.

1.Application Programming Guide
2 SQL Reference
3 Utility Guide and Reference
4 Messages and Codes

If you are an admin then you might need the adminstration Guide.

Once you have narrowed down the list, now you need to choose the version of the software. Depending on the version of DB2 at your shop you can pick the book. Most shops have version 7 in their shop. so you will pick DB2 V7 Application Programming and SQL Guide.

Now search this manual for DSNTIAUL.

Btw The manuals on "quick manuals" link are from the filteration process. so just use them.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu