Reorg - Large dataset

anil mathur

Reorg - Large dataset
Hello List,



We are running DB2 v7.1 for z/OS 1.4



I am running a Reorg on a dataset created as Large. This is a stogroup
defined dataset. The SMS data class was defined with the extended

addressability attribute.



The job abended with the following message.



DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE

REASON 00D70008

TYPE 00000220

NAME WSTBDBPV.DSNDBC.DPWSTB01.SWSTB003.I0001.A001



I have not found any reference to Large in the Reorg chapter of the DB2
utility manual.

What am I missing here ?



Thank you.



Anil Mathur

Database Administration

Harleysville Insurance

215-256-5394 - phone

[login to unmask email]






---------------------------------------------------------------------------------
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

Mark Grundigz

Re: Reorg - Large dataset
(in response to anil mathur)
Anil,

There are no special REORG options to REORG tablespaces defined with either
the LARGE or DSSIZE options that I am aware of. Following are some of the
things you can check to obtain more information

* Check the joblog and messages for z/OS related details
* Check the System Log for messages related to the error
* Check with Storage Management team to make sure that the ACS routines are
coded correctly

Hope this helps.

Mark Grundigz


On Thu, 16 Dec 2004 15:06:46 -0500, Mathur, Anil
<[login to unmask email]> wrote:

>Hello List,
>
>
>
>We are running DB2 v7.1 for z/OS 1.4
>
>
>
>I am running a Reorg on a dataset created as Large. This is a stogroup
>defined dataset. The SMS data class was defined with the extended
>
>addressability attribute.
>
>
>
>The job abended with the following message.
>
>
>
>DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE
>
> REASON 00D70008
>
> TYPE 00000220
>
> NAME WSTBDBPV.DSNDBC.DPWSTB01.SWSTB003.I0001.A001
>
>
>
>I have not found any reference to Large in the Reorg chapter of the DB2
>utility manual.
>
>What am I missing here ?
>
>
>
>Thank you.
>
>
>
>Anil Mathur
>
>Database Administration
>
>Harleysville Insurance
>
>215-256-5394 - phone
>
>[login to unmask email]
>
>
>
>
>
>
>---------------------------------------------------------------------------
------
>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 DB2-L-
[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

Phil Grainger

Re: Reorg - Large dataset
(in response to Mark Grundigz)
but the message text for 00d70008 says that the dataset has NOT been
defined as large. It suggests checking both the dataset class definition
for the "EXT" parameter and making sure that the ACS routines do
allocate the dataset to the right class.....

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mathur, Anil
Sent: 16 December 2004 20:07
To: [login to unmask email]
Subject: Reorg - Large dataset



Hello List,



We are running DB2 v7.1 for z/OS 1.4



I am running a Reorg on a dataset created as Large. This is a stogroup
defined dataset. The SMS data class was defined with the extended

addressability attribute.



The job abended with the following message.



DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE

REASON 00D70008

TYPE 00000220

NAME WSTBDBPV.DSNDBC.DPWSTB01.SWSTB003.I0001.A001



I have not found any reference to Large in the Reorg chapter of the DB2
utility manual.

What am I missing here ?



Thank you.



Anil Mathur

Database Administration

Harleysville Insurance

215-256-5394 - phone

[login to unmask email]





------------------------------------------------------------------------
--------- 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