Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to increase the tablespace in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
abcd.us786

New User


Joined: 06 Dec 2006
Posts: 5
Location: India

PostPosted: Thu Jan 11, 2007 12:48 pm    Post subject: How to increase the tablespace in DB2
Reply with quote

HELLO,

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

REGARDS,

ASHISH.
Back to top
View user's profile Send private message

devidas-patil

New User


Joined: 08 Jan 2007
Posts: 54
Location: pune

PostPosted: Thu Jan 11, 2007 3:24 pm    Post subject: hi this is compiler for db2 compilation
Reply with quote

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
Back to top
View user's profile Send private message
siva001

New User


Joined: 12 Jan 2007
Posts: 9
Location: chennai

PostPosted: Fri Jan 12, 2007 4:43 pm    Post subject:
Reply with quote

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
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 Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us