EDM DBD Space

SUBSCRIBE DB2-L Anil Kale

EDM DBD Space
Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM DBD Space not available.. Before I ask our systems guy to increase the DBD size I need to determine the reason why we get the -904. Any idea how would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: EDM DBD Space
(in response to SUBSCRIBE DB2-L Anil Kale)
Anil,

The cause of your problem _may_ be DBD size for one or more databases.



DBD size increases whenever a table is created, and does not decrease when the table is dropped (except as noted below). For example, if you have a tablespace in your environment which is the target of a lot of QMF SAVE DATA statements, it will grow until it is large enough that it can no longer be loaded.



You can find the size of a DBD by executing the DB2 command:

-DISPLAY DATABASE(dbname)

The response to this command will indicate a DBD size in bytes.



The way to reduce this space, eliminating DBD entries for tables which no longer exist (if that is the cause of your problem), is to run the DB2 MODIFY RECOVERY utility, with the statement:



MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small integer value, a number of days for which you need to retain image copies)



After the MODIFY RECOVERY, a -DISPLAY DATABASE should reveal a smaller DBD. If this database continues to have problems, you might have to DELETE AGE to a smaller AGE value.



--Phil Sevetson



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space



Hi All,



I noticed that lately we get a -904 (resource unavailable) because of EDM DBD Space not available.. Before I ask our systems guy to increase the DBD size I need to determine the reason why we get the -904. Any idea how would I investigate the reason for the -904 (this is on DB2 V9 for z/os).



Thanks.



Anil



_____________________________________________________________________

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *

* Your only source for independent, unbiased, and trusted DB2 information. *

** The most DB2 technical sessions of any conference

** Access IBM experts and developers

_____________________________________________________________________



If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roy Boxwell

Re: EDM DBD Space
(in response to Philip Sevetson)
dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] EDM DBD Space






Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when
the table is dropped (except as noted below). For example, if you have a
tablespace in your environment which is the target of a lot of QMF SAVE
DATA statements, it will grow until it is large enough that it can no
longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no
longer exist (if that is the cause of your problem), is to run the DB2
MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small
integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a –DISPLAY DATABASE should reveal a smaller
DBD. If this database continues to have problems, you might have to
DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM
DBD Space not available.. Before I ask our systems guy to increase the DBD
size I need to determine the reason why we get the -904. Any idea how
would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: EDM DBD Space
(in response to Roy Boxwell)
Roy,

As of several releases ago, the last time I confronted this problem, the MODIFY RECOVERY was all that was needed. Again, this assumes that DBD size due to creates and drops is Anil's problem, of course.

--Phil Sevetson

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Wednesday, December 08, 2010 4:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] EDM DBD Space


dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>

07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An

[login to unmask email]

Kopie



Thema

Re: [DB2-L] EDM DBD Space










Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when the table is dropped (except as noted below). For example, if you have a tablespace in your environment which is the target of a lot of QMF SAVE DATA statements, it will grow until it is large enough that it can no longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no longer exist (if that is the cause of your problem), is to run the DB2 MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a -DISPLAY DATABASE should reveal a smaller DBD. If this database continues to have problems, you might have to DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM DBD Space not available.. Before I ask our systems guy to increase the DBD size I need to determine the reason why we get the -904. Any idea how would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



________________________________

< http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roy Boxwell

Re: EDM DBD Space
(in response to Philip Sevetson)
hmmm...docu (V8, 9 and 10) still states:

Reclaiming space in the DBD
To reclaim space in the DBD when you drop a table, use the following
procedure:
1. Commit the drop.
2. Run the REORG utility.
3. Run the COPY utility to make a full image copy of the table space.
4. Run MODIFY RECOVERY with the DELETE option to delete all previous image
copies.

Looks like something to actually test!


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
08.12.2010 16:10
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] EDM DBD Space






Roy,

As of several releases ago, the last time I confronted this problem, the
MODIFY RECOVERY was all that was needed. Again, this assumes that DBD
size due to creates and drops is Anil’s problem, of course.

--Phil Sevetson


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Wednesday, December 08, 2010 4:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] EDM DBD Space


dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert


"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
07.12.2010 18:39


Bitte antworten an
IDUG DB2-L <[login to unmask email]>



An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] EDM DBD Space









Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when
the table is dropped (except as noted below). For example, if you have a
tablespace in your environment which is the target of a lot of QMF SAVE
DATA statements, it will grow until it is large enough that it can no
longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no
longer exist (if that is the cause of your problem), is to run the DB2
MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small
integer value, a number of days for which you need to retain image copies)


After the MODIFY RECOVERY, a –DISPLAY DATABASE should reveal a smaller
DBD. If this database continues to have problems, you might have to
DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM
DBD Space not available.. Before I ask our systems guy to increase the DBD
size I need to determine the reason why we get the -904. Any idea how
would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv