**************************************************************************
Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
**************************************************************************
:
Pedro,
This is an index on the DB2 catalogs. There are a number of ways to resolve
this issue, reorg could assist, but it's more likely that you need to
increase the space allocation.
There are a number of ways of doing this. From memory DF/DSS may
automatically consolidate extents if you use this utility to move the
dataset. Use the following steps:
1. Stop indexspace DB(DSNDB06) SPACE(DSNHHX01)
2. Move dataset using DF/DSS.
3. Start indexspace DB(DSNDB06) SPACE(DSNHHX01)
If that doesn't work then:
1. Stop indexspace DB(DSNDB06) SPACE(DSNHHX01)
2. Rename the underlying pageset using IDCAMS
3. Allocate a new pageset with larger primary and secondary allocations
4. Start indexspace DB(DSNDB06) SPACE(DSNHHX01)
5. Rebuild the index.
I hope that helps.
David Chapman.
IBM Certified DBA for DB2 UDB on OS/390, Linux, Unix and Windows.
|---------+--------------------------------------------------------->
| | Pedro Miguel Gonçalves |
| | <db2udbdba-ezmlmshield-x34874090.[Email Address Removed] | azyDBA.com> |
| | |
| | 25/08/04 23:57 |
| | |
|---------+--------------------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: LazyDBA Discussion <[Email address protected] |
| cc: |
| Subject: EXTENTS |
>------------------------------------------------------------------------------------------------------------------------------|
Hi guys,
DB2 v.7 OS/390
When running statistics on my Database I ran across the error 00E40207
The job output gives more information as it says:
DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DB2R.DSNDBC.DSNDB06.DSNHHX01.I0001.A001
This VSAM has reached 123 XT, but it belongs to DSNDB06, is it supposed to
reorg it?
I don't think so...
Help pls.
Pedro Gonçalves.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
:
********************************************************************************
The information transmitted in this message and attachments (if any)
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.
If you have received this in error, please contact the sender and delete this
e-mail and associated material from any computer.
The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.
This message has been scanned for viruses and cleared by MailMarshal.
********************************************************************
:
DB2 & UDB email list listserv db2-l LazyDBA home page