Scenario?s where to use DSNTIAUL & DB2UTIL utilities.

jagadeshdvn · New User Joined: 27 Jun 2005 Posts: 14 Location: Chennai

Hello,

Scenario?s where to use DSNTIAUL & DB2UTIL utilities.

Appreciate your help in making me understand these utilities with example.

Thanks in advance!!

Note: I was not sure if this should be posted in DB2 or JCL forum.

Hari Kumar · New User Joined: 28 Jul 2005 Posts: 21

Hi Gagadesh,

DSNTIAUL is unload program. This program, which is written in
assembler language, unloads some or all rows from up to 100 DB2
tables. With DSNTIAUL, you can unload data of any DB2 built-in
data type or distinct type. DSNTIAUL also lets you execute any SQL
non-SELECT statement that can be executed dynamically.

Sample code

jagadeshdvn · New User Joined: 27 Jun 2005 Posts: 14 Location: Chennai

Hi Hari,

Thanks for your time Buddy!

I am working on BMC conversion (from BMC to DB2 utilities) project. I am documenting the process and will share the same once it reaches it logical end.

chidams78 · New User Joined: 29 May 2006 Posts: 2 Location: India

Jagadeesh,

I am also working on BMC conversion project.
Could you please tell me the equivalent DB2 utilites of BMC functions like loadin / unloading and reorganizing, copying the data

Chidams

nuthan · Posted: Wed Oct 17, 2007 5:03 pm Post subject:

Go through the site regarding DBUTIL:
http://www.caspur.it/risorse/softappl/doc/sas_docs/accdb/z0267669.htm

A simple example of an Image Copy job using substring notation is:

//J0000004 JOB (UTILITY,'DATGIO I.B.M.*'),'IMAGE COPY DB497_06 ',
// MSGLEVEL=1,CLASS=K,MSGCLASS=N
//*
//* IMAGE COPY UTILITY
//*
//ICOPY EXEC DB2UTIL,SYSTEM=DB22,UID=J0000004
//*
//DSNUPROC.SYSIN DD *
TEMPLATE COPYDDN1 UNIT(RCART) STACK(YES)
DSN('S&DB(3,4)..IC12.&DB..&TS.')
DISP(MOD,KEEP,KEEP)
TEMPLATE COPYDDN2 UNIT(RCARTDM) STACK(YES)
DSN('S&DB(3,4)..IC22.&DB..&TS.')
DISP(MOD,KEEP,KEEP)
LISTDEF J0000004
INCLUDE TABLESPACE DB497406.TSBRIM
INCLUDE TABLESPACE DB497506.TSBRIM
INCLUDE TABLESPACE DB497606.TSBRIM
INCLUDE TABLESPACE DB497706.TSBRIM
INCLUDE TABLESPACE DB497806.TSBRIM
COPY LIST J0000004 COPYDDN(COPYDDN1,COPYDDN2)
//*

chidams78 · New User Joined: 29 May 2006 Posts: 2 Location: India

I want to replace the following BMC utilities with equivalent DB2 utility

ACPMAIN - COPY PLUS (image copy)
ARUUMAIN - REORG PLUS (reorganizing the datasets)
AMUUMAIN - LOAD PLUS (loading the data)
ADUUMAIN - UNLOAD PLUS (unloading the data)
AFRMAIN - RECOVERY PLUS ( recovery)

ABUDSN - RUNSTATS (used with IKJEFT01 batch monitor pgm
which controls the above utilites)

I found that the euqivalent DB2 utility for LOAD PLUS is DSNTIAUL

Could you please help me for other functions

Rgds
Chidams

gnanasekar80 · New User Joined: 11 Jan 2007 Posts: 6 Location: chennai

Hi jagadesh,

Could you please provide me the process you have followed to convert BMC utilities to DB2 utilities.

Thanks in adavance

Thanks
Gnana