DSNDB06 space reallocation

Joe Gutkovich

DSNDB06 space reallocation
I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve Grimes

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
Hello,

Basically, the steps are to alter the PRIQTY and/or SECQTY for the index
using the ALTER INDEX command, and then doing a Reorg. (Or Rebuild index,
in this case.) You may want to look at Freepage and PCTFree while you're
at it.

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Steve Grimes)
There is a detailed discussion in the administration guide for how to respond to out of space conditions.
Assuming you have not reached the 2 gig limit
1. Image copy the index
2. Stop the index
3. Delete the index
4. Allocate the index
5. Recover the index

Should you be running a version of DB2 that does not do copies of indexes or your shop in general does not do copies then

1. Stop the index
2. Delete the index
3. Allocate the index
4. Rebuild the index


Should you not be experienced in doing any of these steps
Read and ask for a lot of help ... a lost DB2 catalog is no fun at all.

Joe Gutkovich <[login to unmask email]> wrote:

I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
Steve,
Catalog and Directory objects are VCAT defined, not STOGROUP

[login to unmask email] wrote:

Hello,

Basically, the steps are to alter the PRIQTY and/or SECQTY for the index using the ALTER INDEX command, and then doing a Reorg. (Or Rebuild index, in this case.) You may want to look at Freepage and PCTFree while you're at it.

Stg --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
As usual, it depends
1. Quick and dirty - STOP the index, use DF/DSS to copy it, START the index
The result will be a dataset with 5 or less extents for the primary but the
secondary quantity is still the same. DB2 still thinks the primary and
secondary allocation haven't change - reorg will die on space problems, etc.
//ST1 EXEC PGM=ADRDSSU ,PARM='TYPRUN=NORUN'
//SYSPRINT DD SYSOUT=*
//DASD1 DD UNIT=3390,VOL=SER=volser,DISP=OLD
//DASD2 DD UNIT=3390,VOL=SER=volsr2,DISP=OLD
COPY DS(INC( DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001 )) -

INDDNAME(DASD2) OUTDDNAME(DASD2) DELETE CATALOG
If the dataset is SMS managed, don't expect it to show up on the volume you
specify unless you have storage admin authority.
2. A little cleaner - STOP the index , ICDAMS define a new dataset with new
primary and secondary extents, REPRO to the new dataset, rename the old
dataset, rename the new dataset to match DB2 names, START the index.
REMEMBER to rename both the cluster name and the data component - DB2
doesn't like you to play with the dataset names. DB2 still thinks the
primary and secondary allocation haven't change - reorg will die on space
problems, etc.
3. normal DB2 versions slower but safer - Alter the priqty, secqty for the
index, REORG the index. cleaner, slower.

Mike Bell
HLS Technologies



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Joe Gutkovich
Sent: Monday, December 12, 2005 11:10 AM
To: [login to unmask email]
Subject: [DB2-L] DSNDB06 space reallocation

I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Amit Agarwal

Re: DSNDB06 space reallocation
(in response to Mike Bell)
I have used DFDSS in the past to deal with this and had no problems. Here is an example. I usually do it with DB2 down, or
atleast the object stopped. If you search the archives, you will find more discussions on this.

//DB004AD2 JOB 0542,DFDSS-MOVE,CLASS=P,MSGCLASS=X,NOTIFY=DB004
//COPY1 EXEC PGM=ADRDSSU,REGION=4096K
//SYSPRINT DD SYSOUT=*
//INDISK DD UNIT=3390,DISP=SHR,VOL=SER=TEST02
//OUTDISK DD UNIT=3390,DISP=SHR,VOL=SER=DATA17
//SYSIN DD *
COPY DS(INC( ADSN.DSNDBC.DSNDB06.DSNKSX01.I0001.A001 -
)) -
INDD(INDISK) /* TEST02 IS THE SOURCE PACK */ -
OUTDD(OUTDISK) /* DATA17 IS THE NEW VOLUME */ -
FORCE /* FORCE UNMOVEABLE DATASETS */ -
SPHERE /* ADD BY AMIT MOVE RELATED STU */ -
ALLMULTI /* FOR MULTIVOLUME */ -
TOL(ENQF) /* TOLERATE ENQ FAILURE */ -
DELETE /* SCRATCH IT FROM ORIGINAL */ -
ALLX /* COPY EVEN IF DS1LSTAR IS 0 */ -
REP /* REPLACE IF FOUND */ -
RECAT(*) /* RECATALOG DATA */ -
ALLDATA(*) /* MOVE SAM, PAM OR LOADLIBS */
/*

Amit
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Joe Gutkovich
Sent: Monday, December 12, 2005 12:10 PM
To: [login to unmask email]
Subject: [DB2-L] DSNDB06 space reallocation


I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------
The information contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your computer.

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

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DSNDB06 space reallocation
(in response to Amit Agarwal)
I have JCL to move datasets but there are two options here that can be
hazardous.

FORCE - doesn't apply to DB2 datasets, but I wouldn't make it part of my
general copy JCL.
TOL(ENQF) - this does apply to DB2 because it will let the copy process even
if DB2 still has the dataset open. This can leave you with a dataset that
has been moved but DB2 is still applying updates to the old allocation. Not
a very good idea.

BTW - I missed that it was a catalog index. That means you can't use the
reorg or recover to rebuild the index because the catalog is never STOGROUP
defined. If you do the IDCAMS define cluster with a new priqty/secqty, I
would add VOL(* *) to make it multivolume capable.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Agarwal, Amit
Sent: Monday, December 12, 2005 12:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DSNDB06 space reallocation

I have used DFDSS in the past to deal with this and had no problems. Here is
an example. I usually do it with DB2 down, or
atleast the object stopped. If you search the archives, you will find more
discussions on this.

//DB004AD2 JOB 0542,DFDSS-MOVE,CLASS=P,MSGCLASS=X,NOTIFY=DB004
//COPY1 EXEC PGM=ADRDSSU,REGION=4096K
//SYSPRINT DD SYSOUT=*
//INDISK DD UNIT=3390,DISP=SHR,VOL=SER=TEST02
//OUTDISK DD UNIT=3390,DISP=SHR,VOL=SER=DATA17
//SYSIN DD *
COPY DS(INC( ADSN.DSNDBC.DSNDB06.DSNKSX01.I0001.A001 -
)) -
INDD(INDISK) /* TEST02 IS THE SOURCE PACK */ -
OUTDD(OUTDISK) /* DATA17 IS THE NEW VOLUME */ -
FORCE /* FORCE UNMOVEABLE DATASETS */ -
SPHERE /* ADD BY AMIT MOVE RELATED STU */ -
ALLMULTI /* FOR MULTIVOLUME */ -
TOL(ENQF) /* TOLERATE ENQ FAILURE */ -
DELETE /* SCRATCH IT FROM ORIGINAL */ -
ALLX /* COPY EVEN IF DS1LSTAR IS 0 */ -
REP /* REPLACE IF FOUND */ -
RECAT(*) /* RECATALOG DATA */ -
ALLDATA(*) /* MOVE SAM, PAM OR LOADLIBS */
/*

Amit
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Joe Gutkovich
Sent: Monday, December 12, 2005 12:10 PM
To: [login to unmask email]
Subject: [DB2-L] DSNDB06 space reallocation


I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------
The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or may
otherwise be privileged and confidential and protected from disclosure. If
the reader of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended recipient,
please be aware that any dissemination or copying of this communication is
strictly prohibited. If you have received this communication in error,
please immediately notify us by replying to the message and deleting it from
your computer.

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

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Mike Bell)
In general it is a personal preference to answer DB2 questions with DB2 procedures, and preferably documented DB2 procedures.

While use of procedures outside the DB2 world like DFDSS may be valid or better the al least muddy the waters and sometimes create many other issues.

In this case ... The question is clearly posed by a DB2 novice ... Saying "Don't use DB2 and only rely on news group archives for documention" does not seem like good advice to the requestor.

Also, Amit points out, for example the importance of having DB2 down or atleast having the object stopped. The example however contains
"TOL(ENQF) /* TOLERATE ENQ FAILURE */ -"
This ofcourse will cause the copy to happen even if DB2 still has the dataset allocated and opened and could potencially signal the begingings of a long hours of plesent fire fighting and repair.

I will get of my soap box now

"Agarwal, Amit" <[login to unmask email]> wrote:
I have used DFDSS in the past to deal with this and had no problems. Here is an example. I usually do it with DB2 down, or
atleast the object stopped. If you search the archives, you will find more discussions on this.

//DB004AD2 JOB 0542,DFDSS-MOVE,CLASS=P,MSGCLASS=X,NOTIFY=DB004
//COPY1 EXEC PGM=ADRDSSU,REGION=4096K
//SYSPRINT DD SYSOUT=*
//INDISK DD UNIT=3390,DISP=SHR,VOL=SER=TEST02
//OUTDISK DD UNIT=3390,DISP=SHR,VOL=SER=DATA17
//SYSIN DD *
COPY DS(INC( ADSN.DSNDBC.DSNDB06.DSNKSX01.I0001.A001 -
)) -
INDD(INDISK) /* TEST02 IS THE SOURCE PACK */ -
OUTDD(OUTDISK) /* DATA17 IS THE NEW VOLUME */ -
FORCE /* FORCE UNMOVEABLE DATASETS */ -
SPHERE /* ADD BY AMIT MOVE RELATED STU */ -
ALLMULTI /* FOR MULTIVOLUME */ -
TOL(ENQF) /* TOLERATE ENQ FAILURE */ -
DELETE /* SCRATCH IT FROM ORIGINAL */ -
ALLX /* COPY EVEN IF DS1LSTAR IS 0 */ -
REP /* REPLACE IF FOUND */ -
RECAT(*) /* RECATALOG DATA */ -
ALLDATA(*) /* MOVE SAM, PAM OR LOADLIBS */
/*

Amit
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Joe Gutkovich
Sent: Monday, December 12, 2005 12:10 PM
To: [login to unmask email]
Subject: [DB2-L] DSNDB06 space reallocation


I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------
The information contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your computer.

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

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Marcel Harleman

Re: DSNDB06 space reallocation
(in response to Amit Agarwal)
Mike,

> As usual, it depends
>1. Quick and dirty - STOP the index, use DF/DSS to copy it, START the index
>The result will be a dataset with 5 or less extents for the primary but the
>secondary quantity is still the same. DB2 still thinks the primary and
>secondary allocation haven't change - reorg will die on space problems, etc.

I assume you mean STOP - COPY - RESTORE - START? Or HSM
migrate-recall?

And sorry for being a little bit picky, but DB2 doesn't know anything
about primary and secondary quantities since it's user-defined, isn't
it? So this would work for DSNDB06 and DSNDB01, even after a reorg or
a rebuild.
Or am I missing something?

> (...)
>If the dataset is SMS managed, don't expect it to show up on the volume you
>specify unless you have storage admin authority.

Or you need a storage group with the "guaranteed space" attribute
turned on and specify a volume (or the same volume) at recall or
restore.

> (...)

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
Hello,
You can not do ALTER on a SYSIBM index. Is there
another way to increase allocations on a DB2 catalog
index.
ThankU.
JoeG.

--- [login to unmask email] wrote:

> Hello,
>
> Basically, the steps are to alter the PRIQTY and/or
> SECQTY for the index
> using the ALTER INDEX command, and then doing a
> Reorg. (Or Rebuild index,
> in this case.) You may want to look at Freepage and
> PCTFree while you're
> at it.
>
> Stg
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
http://conferences.idug.org/index.cfm


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Amit Agarwal

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
Thanks for pointing that out, Avram. Its better to remove the TOL(ENQF) just in case the object was not stopped.
Also, as he suggests, DFDSS should be used for these types of activities only if you are comfortable using it and have used it before. Else you are better off using documented DB2 procedures.
My intention to direct the user to search the archives for discussion was to look at examples(and issues) others have provided in the past, because I remember someone on the list has helped me before on this issue.......

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Monday, December 12, 2005 1:20 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DSNDB06 space reallocation


In general it is a personal preference to answer DB2 questions with DB2 procedures, and preferably documented DB2 procedures.

While use of procedures outside the DB2 world like DFDSS may be valid or better the al least muddy the waters and sometimes create many other issues.

In this case ... The question is clearly posed by a DB2 novice ... Saying "Don't use DB2 and only rely on news group archives for documention" does not seem like good advice to the requestor.

Also, Amit points out, for example the importance of having DB2 down or atleast having the object stopped. The example however contains
"TOL(ENQF) /* TOLERATE ENQ FAILURE */ -"
This ofcourse will cause the copy to happen even if DB2 still has the dataset allocated and opened and could potencially signal the begingings of a long hours of plesent fire fighting and repair.

I will get of my soap box now

"Agarwal, Amit" <[login to unmask email]> wrote:

I have used DFDSS in the past to deal with this and had no problems. Here is an example. I usually do it with DB2 down, or
atleast the object stopped. If you search the archives, you will find more discussions on this.

//DB004AD2 JOB 0542,DFDSS-MOVE,CLASS=P,MSGCLASS=X,NOTIFY=DB004
//COPY1 EXEC PGM=ADRDSSU,REGION=4096K
//SYSPRINT DD SYSOUT=*
//INDISK DD UNIT=3390,DISP=SHR,VOL=SER=TEST02
//OUTDISK DD UNIT=3390,DISP=SHR,VOL=SER=DATA17
//SYSIN DD *
COPY DS(INC( ADSN.DSNDBC.DSNDB06.DSNKSX01.I0001.A001 -
)) -
INDD(INDISK) /* TEST02 IS THE SOURCE PACK */ -
OUTDD(OUTDISK) /* DATA17 IS THE NEW VOLUME */ -
FORCE /* FORCE UNMOVEABLE DATASETS */ -
SPHERE /* ADD BY AMIT MOVE RELATED STU */ -
ALLMULTI /* FOR MULTIVOLUME */ -
TOL(ENQF) /* TOLERATE ENQ FAILURE */ -
DELETE /* SCRATCH IT FROM ORIGINAL */ -
ALLX /* COPY EVEN IF DS1LSTAR IS 0 */ -
REP /* REPLACE IF FOUND */ -
RECAT(*) /* RECATALOG DATA */ -
ALLDATA(*) /* MOVE SAM, PAM OR LOADLIBS */
/*

Amit
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Joe Gutkovich
Sent: Monday, December 12, 2005 12:10 PM
To: [login to unmask email]
Subject: [DB2-L] DSNDB06 space reallocation


I am getting an
- RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
How can I increase the space allocations for this index?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------
The information contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your computer.

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

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Marcel Harleman)
Hello,
and ThankU very much for your answer. I like #3, but
as far as I can tell (and I tryed) You can not issue
an ALTER command for the SYSIBM index. It's an index
on the SYSCOPY table. I can reorg SYSCOPY and all it's
indexes, bit I can't ALTER the Primary/Secondary. Any
suggestions.
JoeG.

--- Mike Bell <[login to unmask email]> wrote:

> As usual, it depends
> 1. Quick and dirty - STOP the index, use DF/DSS to
> copy it, START the index
> The result will be a dataset with 5 or less extents
> for the primary but the
> secondary quantity is still the same. DB2 still
> thinks the primary and
> secondary allocation haven't change - reorg will die
> on space problems, etc.
> //ST1 EXEC PGM=ADRDSSU
> ,PARM='TYPRUN=NORUN'
> //SYSPRINT DD SYSOUT=*
>
> //DASD1 DD UNIT=3390,VOL=SER=volser,DISP=OLD
>
> //DASD2 DD UNIT=3390,VOL=SER=volsr2,DISP=OLD
>
> COPY DS(INC(
> DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001 )) -
>
> INDDNAME(DASD2) OUTDDNAME(DASD2) DELETE CATALOG
>
> If the dataset is SMS managed, don't expect it to
> show up on the volume you
> specify unless you have storage admin authority.
> 2. A little cleaner - STOP the index , ICDAMS define
> a new dataset with new
> primary and secondary extents, REPRO to the new
> dataset, rename the old
> dataset, rename the new dataset to match DB2 names,
> START the index.
> REMEMBER to rename both the cluster name and the
> data component - DB2
> doesn't like you to play with the dataset names. DB2
> still thinks the
> primary and secondary allocation haven't change -
> reorg will die on space
> problems, etc.
> 3. normal DB2 versions slower but safer - Alter the
> priqty, secqty for the
> index, REORG the index. cleaner, slower.
>
> Mike Bell
> HLS Technologies
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf
> Of Joe Gutkovich
> Sent: Monday, December 12, 2005 11:10 AM
> To: [login to unmask email]
> Subject: [DB2-L] DSNDB06 space reallocation
>
> I am getting an
> - RESOURCE UNAVAILABLE
> REASON 00D70014
> TYPE 00000220
> NAME DSNC130.DSNDBC.DSNDB06.DSNUCX01.I0001.A001
> How can I increase the space allocations for this
> index?
>
>
----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home
> page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at
> [login to unmask email] Find
> out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system
> (http://www.grisoft.com).
> Version: 6.0.510 / Virus Database: 307 - Release
> Date: 8/14/2003
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system
> (http://www.grisoft.com).
> Version: 6.0.510 / Virus Database: 307 - Release
> Date: 8/14/2003
>
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
> http://conferences.idug.org/index.cfm
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
CATALOG AND DIRECTORY OBJECTS ARE VCAT DEFINED,
NOT STOGROUP

YOU MUST USE IDCAMS TO CHANGE THE ALLOCATION

PLEASE PLEASE PLEASE FOLLOW THE DIRECTIONS IN THE SYS ADM GUIDE. PLAYING WITH THE CATALOG IS NOT THE TIME TO SHOW PEOPLE HOW BRILLANT YOU ARE BECAUSE YOU DON'T HAVE TO FOLLOW THE DIRECTIONS.

Joe Gutkovich <[login to unmask email]> wrote:
Hello,
You can not do ALTER on a SYSIBM index. Is there
another way to increase allocations on a DB2 catalog
index.
ThankU.
JoeG.

--- [login to unmask email] wrote:

> Hello,
>
> Basically, the steps are to alter the PRIQTY and/or
> SECQTY for the index
> using the ALTER INDEX command, and then doing a
> Reorg. (Or Rebuild index,
> in this case.) You may want to look at Freepage and
> PCTFree while you're
> at it.
>
> Stg
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
http://conferences.idug.org/index.cfm


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Steve Grimes)
I am doing this for 20 years, but maybe I am still new. The way I dealt
with the problem is MODIFY/REORG. It works and its strict DB@. I do not
really understand what SYS ADM guide is meant here? Could You please be
more specific? DB2 Administration Guide has nothing on the subject as far
as I camn tell. IF thiss needs to be handled outside of DB2, using IDCAMS -
then what is the sequence of events? ThankU again.
JoeG.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
Sorry about the yelling in the last note.

I get the strong impression that you are new at this.
While the process is fairly trivial you see at least in two examples the 'experts' got it wrong.

Do not distroy your DB2 system
Do it by the book SYS ADM Guide
Given your newness open a problem with IBM and have them hold your hand while you do it.

They would much rather help you now than help you with a lost non recoverable catalog.

This is not the time for any one to act too macho.

[login to unmask email] wrote:
CATALOG AND DIRECTORY OBJECTS ARE VCAT DEFINED,
NOT STOGROUP

YOU MUST USE IDCAMS TO CHANGE THE ALLOCATION

PLEASE PLEASE PLEASE FOLLOW THE DIRECTIONS IN THE SYS ADM GUIDE. PLAYING WITH THE CATALOG IS NOT THE TIME TO SHOW PEOPLE HOW BRILLANT YOU ARE BECAUSE YOU DON'T HAVE TO FOLLOW THE DIRECTIONS.

Joe Gutkovich <[login to unmask email]> wrote:
Hello,
You can not do ALTER on a SYSIBM index. Is there
another way to increase allocations on a DB2 catalog
index.
ThankU.
JoeG.

--- [login to unmask email] wrote:

> Hello,
>
> Basically, the steps are to alter the PRIQTY and/or
> SECQTY for the index
> using the ALTER INDEX command, and then doing a
> Reorg. (Or Rebuild index,
> in this case.) You may want to look at Freepage and
> PCTFree while you're
> at it.
>
> Stg
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
http://conferences.idug.org/index.cfm


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com







Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steve Grimes

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
Oooops -- sorry. I did't catch which index it was.

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
Give me a break Joe

One can not modify the space on a VCAT defined object like the catalog

The ability to do REORGS on the DB2 catalog / directory has not been around for 20 years

The book title is "Title: DB2 UDB for z/OS V8 Administration Guide"

Of course diffrent versions have diffrent titles

In the V8 copy
Section 4.7 is called Recovery Scenarios

There has been a Recovery Scenarios section in the ADM Guide since first customer ship in the early 80's

4.7.14.2 Out of disk space or extent limit recovery
is what you need to look at


there are 7 defined procedures


Procedure 1. Extend a data set in topic 4.7.14.2

Procedure 2. Enlarge a fully extended data set (user-managed) in topic 4.7.14.2

Procedure 3. Enlarge a fully extended data set (in a DB2 storage group) in topic 4.7.14.2

Procedure 4. Add a data set in topic 4.7.14.2

Procedure 5. Redefine a partition (index-based partitioning) in topic 4.7.14.2

| Procedure 6. Redefine a partition (table-based partitioning) in
| topic 4.7.14.2

| Procedure 7. Enlarge a fully extended data set for the work file
| database in topic 4.7.14.2

NOTICE PROCEDURE 2 for user managed objects (VCAT) is not the same as PROCEDURE 3 for DB2 storage groups. At least the procedure number is diffrent.


Joe Gutkovich <[login to unmask email]> wrote:
I am doing this for 20 years, but maybe I am still new. The way I dealt
with the problem is MODIFY/REORG. It works and its strict DB@. I do not
really understand what SYS ADM guide is meant here? Could You please be
more specific? DB2 Administration Guide has nothing on the subject as far
as I camn tell. IF thiss needs to be handled outside of DB2, using IDCAMS -
then what is the sequence of events? ThankU again.
JoeG.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
1. I ment MODIFY utility. Which I did ran and does
help in this scenario.
2. I ment I've been around for 20 years (actually
24.5), not REORG on the catalog.
3. I've looked at all the sections You so kindly
priovided the links for. None of them however relates
to what I need, which is simply to increase
allocations on the CATALOG index.
4. I think I found an answer in some old postes on
this subject:

>1) Dataset
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>is in 10 extents.
>
>2) Allocate
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001
>with more primary and secondary space. Notice the
'X' in the last
>qualifier.
>
>3) Shutdown DB2.
>
>4) Use DSN1COPY to copy
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001.
>
>5) ALTER
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.Y001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.Y001.
>Notice the 'Y' in the last qualifier.
>
>6) ALTER
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001.
>Notice the 'X' in the last qualifier.
>
>7) Start DB2
>
>8) DELETE
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.Y001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.Y001.
>Notice the 'Y' in the last qualifier.
>
I think this is what needs to be done. Any comments
(or similarluy comprehensive) answers on the subject
(not on how smart or experienced this or that person
is) would be greatly appreciated.
JoeG.



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
From the Adm Guide V8

Procedure 1 is for datasets that have not reached max size or max extents but have run out of space on the volume

Procedure 2 is for datasets that have not reached max size but not max extents

Proceure 4, is for datasets that have reached max size typically 2 gig... you simply add an addtional dataset

Procedure 1. Extend a data set: If the data set is user-defined, provide more VSAM space. You can add volumes with the access method services command ALTER ADDVOLUMES or make room on the current volume.
If the data set is defined in a DB2 storage group, add more volumes to the storage group by using the SQL ALTER STOGROUP statement. For more information about DB2 data set extension, refer to "Extending DB2-managed data sets" in topic 2.2.1.4. Procedure 2. Enlarge a fully extended data set (user-managed):
To allow for recovery in case of failure during this procedure, be sure that you have a recent full image copy (for table spaces or if you copy your indexes). Use the DSNUM option to identify the data set for table spaces or partitioning indexes.

Issue the command STOP DATABASE SPACENAM for the last data set of the object supported.

Delete the last data set by using access method services. Then redefine it and enlarge it as necessary.
| The object must be user-defined and a linear data set, and should not
| have reached the maximum number of 32 data sets for a nonpartitioned
| table space (or 254 data sets for LOB table spaces). For a partitioned
| table space, a partitioning index, or a nonpartitioning index on a
| partitioned table space, the maximum is 4096 data sets.

Issue the command START DATABASE ACCESS (UT) to start the object for utility-only access.

To recover the data set that was redefined, use RECOVER on the table space or index, and identify the data set by the DSNUM option (specify this DSNUM option for table spaces or partitioning indexes only). RECOVER lets you specify a single data set number for a table space. Thus, only the last data set (the one that needs extension) must be redefined and recovered. This can be better than using REORG if the table space is very large and contains multiple data sets, and if the extension must be done quickly. If you do not copy your indexes, then use the REBUILD INDEX utility.

Issue the command START DATABASE to start the object for either RO or RW access, whichever is appropriate.
Procedure 4. Add a data set: If the object supported is user-defined, use the access method services to define another data set. The name of the new data set must continue the sequence begun by the names of the existing data sets that support the object. The last four characters of each name are a relative data set number: If the last name ended with A001, the next must end with A002, and so on. Also, be sure to add either I or J in the name of the data set.
If the object is defined in a DB2 storage group, DB2 automatically tries to create an additional data set. If that fails, access method services messages are sent to an operator indicating the cause of the problem. Correcting that problem allows DB2 to get the additional space.








In my first note I provided the user with an outline of procedure 2 and suggested he RFM DOn't know why these procedures were left out of your publications.

Joe Gutkovich <[login to unmask email]> wrote:
1. I ment MODIFY utility. Which I did ran and does
help in this scenario.
2. I ment I've been around for 20 years (actually
24.5), not REORG on the catalog.
3. I've looked at all the sections You so kindly
priovided the links for. None of them however relates
to what I need, which is simply to increase
allocations on the CATALOG index.
4. I think I found an answer in some old postes on
this subject:

>1) Dataset
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>is in 10 extents.
>
>2) Allocate
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001
>with more primary and secondary space. Notice the
'X' in the last
>qualifier.
>
>3) Shutdown DB2.
>
>4) Use DSN1COPY to copy
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001.
>
>5) ALTER
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.Y001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.Y001.
>Notice the 'Y' in the last qualifier.
>
>6) ALTER
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.X001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.X001
>to
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.A001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.A001.
>Notice the 'X' in the last qualifier.
>
>7) Start DB2
>
>8) DELETE
>high-level-qual.DSNDBC.DSNDB06.object_name.I0001.Y001
or
>high-level-qual.DSNDBC.DSNDB01.object_name.I0001.Y001.
>Notice the 'Y' in the last qualifier.
>
I think this is what needs to be done. Any comments
(or similarluy comprehensive) answers on the subject
(not on how smart or experienced this or that person
is) would be greatly appreciated.
JoeG.



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Avram Friedman)
Procedure 1: "...If the data set is user-defined..."
Procedure 2: "... fully extended data set
(user-managed)..."
Procedure 4: "... If the object supported is
user-defined..."

May I point out yet again (being new and all) that the
object under discussion is DSNC130.DSNDBC.DSNDB06.
DSNUCX01.I0001.A001, which is not user-defined at all.







__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Charles Crockett

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
In the techno speak of DB2, there are 2 choices on how datasets get
created:

DB2 defined, also known as STOGROUP defined, and
User defined, also known as IDCAMS defined

You are confusing a true 'user defined' idcams dataset, where a user
might use any IDCAMS parameter they want,
with an IBM specification as to exactly what parameters to use for the
DB2 catalog & directory, but the catalog & directory are still 'user
defined' by the above definition.

Charles Crockett



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Joe Gutkovich
Sent: Monday, December 12, 2005 1:50 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DSNDB06 space reallocation


Procedure 1: "...If the data set is user-defined..."
Procedure 2: "... fully extended data set
(user-managed)..."
Procedure 4: "... If the object supported is
user-defined..."

May I point out yet again (being new and all) that the
object under discussion is DSNC130.DSNDBC.DSNDB06. DSNUCX01.I0001.A001,
which is not user-defined at all.







__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ford Wong

Re: DSNDB06 space reallocation
(in response to Charles Crockett)
Hello,

DSNUCX01 is a USER DEFINED Dataset. In fact, all the DB2 CATALOG/DIRECTORY
pagesets are USER DEFINED (unless this has changed in new releases).

The best way to resize any DB2 CATALOG/DIRECTORY pageset is to do the
following basic procedure:

1. UNLOAD Tablespace either by making (a) an IMAGE COPY or (b) Running the
first part of REORG with UNLOAD CONTINUE. Note: not all the DB2
CATALOG/DIRECTORY Tablespaces can be REORGED. If not the use the first
method.

2. STOP THE TABLESPACE.

3. Use IDCAMS to RENAME the existing underlying dataset. You could delete
the dataset but RENAMING gives you a fallback if all goes wrong...

4. REDEFINE the dataset with the new sizes (eg. see INSTALL job
xxxx.xxxx.SDSNSMP(DSNTIJIN).

If you want to be extra careful, I always initialize the new defined
datasets using the IBM supplied job. SDSNSAMP(DSNTIJID). It avoids any
possible C90201? type errors.

5. Start the Tablespace, etc.

6. Depending on how you unloaded the Tablespace, do one of the following:
(a). RECOVER the tablespace and REBUILD INDEXES.
(b). Continue with the STOPPED REORG UTILITY.

COMMENT: Since DSNUCX01 is an index, I believe that you don't need to
unload or run reorg but after redefining the dataset you just
run REBUILD index.

Note: there are other tricky ways to resize a tablespace which involve
some risk. eg. HSM Migrate and HSM Recall.... Another way, I believe
that you could also DSN1COPY to copy from old to new (but have never tried
this) ... But why not stick with the standard IBM DB2 way....

7. After loading the Tablespace, or running REORG, make and Image copy.

These are my opinions only based on what I recall when I used to have to do
this stuff.

Ford

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joe Gutkovich

Re: DSNDB06 space reallocation
(in response to Ford Wong)
ThankU very much. This was very useful to me. I'll do what You suggested.
JoeG.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Paul Fegan

Re: DSNDB06 space reallocation
(in response to Joe Gutkovich)
If you've got HSM and the index isn't too large to fit on your ML1 packs.
Stop the index migate it to disk (HMIG) and then recall it (HREC). HSM
will consolidate the extents for you. If you want it much larger than it's
current size you'll need to go back to the VSAM delete, allocate and
reduild options mentioned in previous posts.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm