DB2 V7 IBM Admin Tool Issue

Kirk Hampton

DB2 V7 IBM Admin Tool Issue
We have run into a few situations with the IBM DB2 Admin Tool v7,

running on DB2 v7 on z/OS 1.7,

where it abends with a memory failure.



We have the vast majority of our TSO users still set at a late-80's size

of 4096K. Increasing that to

8192K gets us around the abends. I know that many batch jobs run with

REGION=0M.



For you medium sized shops, say, 1500 to 3000 MIPS, what is your typical

TSO size and/or batch

REGION size ?



Thanks,

Kirk Hampton

DB2 z/OS Sysprog

IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS

Capgemini Energy

Dallas, Texas





________________________________



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On

Behalf Of McCormack, Mark A

Sent: Wednesday, January 17, 2007 9:47 AM

To: [login to unmask email]

Subject: [DB2-L] DB2 V8 Load Issue







<You want to allocate a lot of memory. This was the most common failure

for us.>



I wish to reinforce David Simpson's suggestion. The change from

Syncsort to DFSORT caused us to make serious changes to our reorg procs.

We increased region size from 6M to 256M.



Mark



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

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



Confidentiality Notice: This email message, including any attachments, contains or may contain confidential information intended only for the addressee. If you are not an intended recipient of this message, be advised that any reading, dissemination, forwarding, printing, copying or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately by reply message and delete this email message and any attachments from your system.


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

David CIV DISA CDB Lucier

Re: DB2 V7 IBM Admin Tool Issue
(in response to Kirk Hampton)
We have been able to settle on 6144K for TSO and either 6M or 0M for
batch.
David Lucier
Database Support
DSN 430.7629
Comm 717.605.7629




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Kirk Hampton
Sent: Wednesday, January 17, 2007 11:43 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 IBM Admin Tool Issue

We have run into a few situations with the IBM DB2 Admin Tool v7,
running on DB2 v7 on z/OS 1.7, where it abends with a memory failure.

We have the vast majority of our TSO users still set at a late-80's size
of 4096K. Increasing that to 8192K gets us around the abends. I know
that many batch jobs run with REGION=0M.

For you medium sized shops, say, 1500 to 3000 MIPS, what is your typical
TSO size and/or batch REGION size ?

Thanks,
Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS Capgemini
Energy Dallas, Texas


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McCormack, Mark A
Sent: Wednesday, January 17, 2007 9:47 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Load Issue



<You want to allocate a lot of memory. This was the most common failure
for us.>

I wish to reinforce David Simpson's suggestion. The change from
Syncsort to DFSORT caused us to make serious changes to our reorg procs.
We increased region size from 6M to 256M.

Mark

------------------------------------------------------------------------
--------- 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.cfmConfidentiality Notice: This
email message, including any attachments, contains or may contain
confidential information intended only for the addressee. If you are not
an intended recipient of this message, be advised that any reading,
dissemination, forwarding, printing, copying or other use of this
message or its attachments is strictly prohibited. If you have received
this message in error, please notify the sender immediately by reply
message and delete this email message and any attachments from your
system.
------------------------------------------------------------------------
--------- 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

Jim Tobin

Re: DB2 V7 IBM Admin Tool Issue
(in response to David CIV DISA CDB Lucier)
Kirk,

I also experienced same issue after I upgraded Admin Tool from V4.2 to
V7.1. V4.2 ran fine with 4096K for all TSO users. V7.1 had issues with
4096K (GEN line command I believe). Having TSO users bump up to 8192K,
as a test, resolved the issue.

BTW, z/OS prevents them (or myself) from bumping higher than 8192K on
this LPAR.

Regards,
Jim Tobin
Online and Database Systems Programming Support
(973) 533-2637
[login to unmask email]


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Kirk Hampton
Sent: Wednesday, January 17, 2007 11:43 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 IBM Admin Tool Issue


We have run into a few situations with the IBM DB2 Admin Tool v7,
running on DB2 v7 on z/OS 1.7,
where it abends with a memory failure.

We have the vast majority of our TSO users still set at a late-80's size
of 4096K. Increasing that to
8192K gets us around the abends. I know that many batch jobs run with
REGION=0M.

For you medium sized shops, say, 1500 to 3000 MIPS, what is your typical
TSO size and/or batch
REGION size ?

Thanks,
Kirk Hampton
DB2 z/OS Sysprog
IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS
Capgemini Energy
Dallas, Texas


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McCormack, Mark A
Sent: Wednesday, January 17, 2007 9:47 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V8 Load Issue



<You want to allocate a lot of memory. This was the most common failure
for us.>

I wish to reinforce David Simpson's suggestion. The change from
Syncsort to DFSORT caused us to make serious changes to our reorg procs.
We increased region size from 6M to 256M.

Mark

------------------------------------------------------------------------
--------- 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.cfmConfidentiality Notice: This
email message, including any attachments, contains or may contain
confidential information intended only for the addressee. If you are not
an intended recipient of this message, be advised that any reading,
dissemination, forwarding, printing, copying or other use of this
message or its attachments is strictly prohibited. If you have received
this message in error, please notify the sender immediately by reply
message and delete this email message and any attachments from your
system.
------------------------------------------------------------------------
--------- 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