How to increase the tablespace in DB2

abcd.us786 · New User Joined: 06 Dec 2006 Posts: 5 Location: India

HELLO,

I WANTED TO KNOW THAT HOW TO INCREASE A TABLESPACE IN DB2 ALSO I WANTED A DB2 COMPILER FOR Z/OS..

REGARDS,

ASHISH.

devidas-patil · New User Joined: 08 Jan 2007 Posts: 54 Location: pune

hi i dont know ho to increase the size but ihave the compiler
first u have to comple then bind finaly run the program..
COMPILER:

***************************** Top of Data ******************************
//MTPLP06C JOB ,,NOTIFY=&SYSUID,CLASS=A,MSGLEVEL=(1,1),MSGCLASS=H
//JOBPROC JCLLIB ORDER=IBMUSER.COMPILER.JCLS
//*SYSPRINT DD SYSOUT=*
//EXEC1 EXEC DB2JCL,
// SRCLIB=MTPLP07.DB.PDS, --> SOURCE LIB
// DBRMLIB=MTPLP07.DB1.PDS, --> DBRM LIBRARY
// MEM=CREATE1, --> MEMBER NAME
// DCLLIB=MTPLP07.DB2.PDS, --> DCLGEN LIBRARY
//* COPYLIB=MTPLP06.COPY.LIB, --> COPY LIBRARY
// LOADLIB=MTPLP07.DB3.PDS --> LOAD LIBRARY
**************************** Bottom of Data ****************************

THIS FOR BIND
***************************** Top of Data ******************************
//MTPLP05B JOB ,,NOTIFY=&SYSUID,CLASS=A,MSGLEVEL=(1,1),MSGCLASS=H
//JOBLIB DD DISP=SHR,
// DSN=DSN710.SDSNEXIT
// DD DISP=SHR,
// DSN=DSN710.SDSNLOAD
//BIND EXEC PGM=IKJEFT01,DYNAMNBR=20
//DBRMLIB DD DISP=SHR,
// DSN=MTPLP07.DB1.PDS --> DBRM LIBRARY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUMUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//REPORT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN1)
BIND PLAN(MTPLP05B) MEMBER(CREATE1) ISOLATION(RR) ACTION(REP)

FINALY RUN

***************************** Top of Data ******************************
//MTPLP05P JOB ,,NOTIFY=&SYSUID,CLASS=A,MSGLEVEL=(1,1),MSGCLASS=H,
// LINES=(1,CANCEL)
//JOBLIB DD DISP=SHR,
// DSN=DSN710.SDSNEXIT
// DD DISP=SHR,
// DSN=DSN710.SDSNLOAD
// DD DISP=SHR,
// DSN=CEE.SCEERUN
//PH02CS04 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//*SYSIN DD DUMMY
//SYSIN DD *
//SYSTSIN DD *
DSN SYSTEM(DSN1)
RUN PROGRAM(CREATE1) PLAN(MTPLP05B) LIB('MTPLP07.DB3.PDS')
END

siva001 · New User Joined: 12 Jan 2007 Posts: 9 Location: chennai

if u want to increase table space storage volume below jckl is use ful
//SWBXR02A JOB ACCT,'REORG RESIZED TBL',MSGCLASS=Q,
// MSGLEVEL=(1,1),REGION=8M,COND=(4,LT),
// CLASS=D,NOTIFY=&SYSUID
//*--------------------------------------------------------------
//* STOP OBJECTS
//*--------------------------------------------------------------
//STEP010 EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=SYSD0.DB2.DSN3.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN3) RETRY(0) TEST(0)
-STOP DATABASE(DOMS3SVI) SPACENAM(SCNTE)
END
/*
//*--------------------------------------------------------------
//* ALTER SIZES
//*--------------------------------------------------------------
//STEP020 EXEC PGM=IKJEFT01,COND=(4,LT)
//STEPLIB DD DSN=SYSD0.DB2.DSN3.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN3)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
LIB('SYSD0.DB2.DSN3.RUNLIB.LOAD')
//SYSIN DD *
SET CURRENT SQLID = 'OMS3DBA';
ALTER TABLESPACE DOMS3SVI.SCNTE
USING STOGROUP GOMS3P64

/*
//* START OBJECT RW
//*---------------------------------------------------
//STEP030 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//STEPLIB DD DSN=SYSD0.DB2.DSN3.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN3) RETRY(0) TEST(0)
-START DATABASE(DOMS3SVI)SPACE(SCNTE) ACCESS(RW)
END
/*

after u have to reorg for that table space

Bye
shiva