Need information about Load and Unload Utility

Manojudha · New User Joined: 13 Jul 2005 Posts: 13

Hi,

I am not understanding the Load/ Unload utility..

Could somone provide me information on this.

Thanks.

daredevil · New User Joined: 30 Dec 2005 Posts: 9

Hi,

Refer to " DB2/UDB V8 Utility Guide " for details and expalnation about load/unload utilities.

This material is available in the same forum.

Thanks
Daredevil

shammiullah · New User Joined: 13 Jun 2005 Posts: 24

hi,

Hi,
unload tility is used for taking a backup of a TABLE INTO A FLAT FILE.
LOAD UTILITY IS FOR LOADING A FLAT FILE RECORDS INTO A TABLE.

UNLOAD UTILITY::

//SYSREC00 DD DSN=NUUST.IMR.RTRV.DATA,-DISP=(NEW,CATLG,DELETE)
--THIS IS THE PS WHERE THE BACKUP'LL B STORED
//
//SYSIN DD *
SELECT * FROM TABLENAME;
//

habibullah_j · New User Joined: 16 Mar 2006 Posts: 3

hi all,
Load is to upload data into a table. (Restore process)
Unload is to download data into a table.(Backup process)
Please do revert it back if i'm wrong.

cheers,
habib

-----------------load process-------------------------------------------
/LOADCUST EXEC PGM=DSNUTILB'
//STEPLIB DD DSN=SYS4.DB2.DB2T.SDSNEXIT,DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNLOAD,DISP=SHR
//SYSERR DD SPACE=(TRK,(200,11),RLSE),UNIT=SYSDA
//SYSMAP DD SPACE=(CYL,(400,11),RLSE),UNIT=SYSDA
//SYSDISC DD SPACE=(TRK,(200,11),RLSE),UNIT=SYSDA
//SYSUT1 DD SPACE=(CYL,(100,300)),UNIT=(SYSDA,4)
//SORTOUT DD SPACE=(CYL,(100,300)),UNIT=(SYSDA,4)
//SORTWK01 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK02 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK03 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK04 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK05 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SORTWK06 DD SPACE=(CYL,(100,200),RLSE),UNIT=(SYSDA,4)
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD DISP=SHR,DSN=<<member>
//SYSREC DD DISP=SHR,DSN=<member>
-----------------------------------------------------------------------------
-----------------unload process-------------------------------------------
//jobcard........
//*
//UNLAD EXEC PGM=INZUTILB,PARM='DB2T,FASTUNLD'
//STEPLIB DD DSN=SYS4.DB2TOOLS.SINZLINK,
// DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNEXIT,DISP=SHR
// DD DSN=SYS4.DB2.DB2T.SDSNLOAD,DISP=SHR
//SYSREC DD DSN=<member>,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(1,1),RLSE)
//SYSPUNCH DD DSN=<member>
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(TRK,(1,1),RLSE)
//UTPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSIN DD *
UNLOAD TABLESPACE <tablespace>
DB2 YES
LOCK NO QUIESCE NO QUIESCECAT NO
SELECT *
FROM <schema>.<tablename>
ORDER CLUSTER
OUTDDN ( SYSREC )
FORMAT DSNTIAUL
LOADDDN SYSPUNCH
LOADOPT (
NOKEEPDICTIONARY
RESUME NO REPLACE STATISTICS TABLE(ALL) INDEX(ALL) UPDATE ALL 00490000
SORTKEYS 4
ENFORCE NO
LOG NO )
/*

Jag · New User Joined: 07 Dec 2005 Posts: 30 Location: India

The basic concepts load and unload comes when you wnat to production data in the test ernvironment where we do our all the research work

..In the load process we unload all the productiond data into a samf file.... In the Load process we will be loading the data from the SAMF files to the test region database..

While loading the database we will load the parent table first and child tables in order maintain the referntial integrity...There are more concepts like Check Pending,Copy Pending,RunStats,Reorg Concepts related to this Unload and Load concepts..Please read this form the book..Feel Free to raise the doubts..As so many people are waiting to know variety of questions and so many people are there to answer as well
..

Cheers,
Jag.
Email: ***EMail ID REMOVED... Read Forum Rules***

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

Can you tell me what SMAF file means??

SharathG · New User Joined: 23 Jan 2007 Posts: 12 Location: India

Hi Jag,

While unloading Production data into sequential files, is there an option to mask some sensitive columns and then unload them onto sequential files? As Production database contains customer sensitive information, masking becomes absolutely necessary. Any ideas? Also, is there a way to unload only selected rows from tables. I think there is one but I dont know the exact method. Thanks...

kgumraj2 · New User Joined: 01 Aug 2007 Posts: 42 Location: Hyderabad

Hi,

In Unload JCL, SYSIN does the trick for you.

dick scherrer · Posted: Thu Aug 02, 2007 8:10 pm

Hello,

Jag · New User Joined: 07 Dec 2005 Posts: 30 Location: India

Regarding masking certain User sentive columns as per my knowledge its not possiblem...

But there is an another turn around to do this..

We can always create a table eliminating perticular columns of the base or original table and unload from that table...

Cheers,
Jag

dick scherrer · Posted: Fri Aug 03, 2007 7:27 pm

Hello,

For this