IBM DB2 Automation tool question

Raquel Rodriguez

IBM DB2 Automation tool question
Am receiving warning code BCTB141W when generating
Reorgs by IBM's "DB2 Automation Tool". Google has
following to say:

BCTB141W: space_type creator|database space_name
partition_number Prime and Secd Space necessary for
allocation have been truncated to user specified qty

Explanation: The listed object’s primary and secondary
allocations were truncated due to the user-specified
maximum space allocation limits.

User Response: The job will probably fail due to lack
of space. Re-evaluate your maximum space quantity
allocations.

So, as per the message, there is a 'user-specified
maximum space allocation limit'. Where in the tool is
this space allocation limit specified by the user? I
could not locate it.

TIA
Raquel.



__________________________________________________
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

Phil Grainger

FW: IBM DB2 Automation tool question
(in response to Raquel Rodriguez)
Fyi - read on

You can configure IBMs Automation Tool to generate reorgs that "may
fail" due to insufficient workfile space

Good eh!


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]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raquel Rodriguez
Sent: 02 December 2004 18:00
To: [login to unmask email]
Subject: IBM DB2 Automation tool question

Am receiving warning code BCTB141W when generating Reorgs by IBM's "DB2
Automation Tool". Google has following to say:

BCTB141W: space_type creator|database space_name partition_number Prime
and Secd Space necessary for allocation have been truncated to user
specified qty

Explanation: The listed object's primary and secondary allocations were
truncated due to the user-specified maximum space allocation limits.

User Response: The job will probably fail due to lack of space.
Re-evaluate your maximum space quantity allocations.

So, as per the message, there is a 'user-specified maximum space
allocation limit'. Where in the tool is this space allocation limit
specified by the user? I could not locate it.

TIA
Raquel.



__________________________________________________
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

Mark Vickers

Re: IBM DB2 Automation tool question
(in response to Phil Grainger)
Raquel,
I am just setting up the tool myself, so I am not a fundi by any stretch of
the imagination.
I am making the assumption this is workfile space and the only setting I
found is in:
SETUP > 3:DB2 Shared Profile Support:
Max Primary Space Allocation ==> 000300 (1-999999) C (Trks/Cyls/Mbytes)
F1 yields:
Limits the amount of space that can be allocated for a primary allocation.
Valid values can be specified in tracks, cylinders, or megabytes.


I have just tested a fairly large reorg (13GB for TS & IX's) and used 300
cylinders and it worked fine.

Mark.

-----Original Message-----
From: Raquel Rodriguez [mailto:[login to unmask email]
Sent: Thursday, December 02, 2004 12:00 PM
To: [login to unmask email]
Subject: IBM DB2 Automation tool question

Am receiving warning code BCTB141W when generating
Reorgs by IBM's "DB2 Automation Tool". Google has
following to say:

BCTB141W: space_type creator|database space_name
partition_number Prime and Secd Space necessary for
allocation have been truncated to user specified qty

Explanation: The listed object's primary and secondary
allocations were truncated due to the user-specified
maximum space allocation limits.

User Response: The job will probably fail due to lack
of space. Re-evaluate your maximum space quantity
allocations.

So, as per the message, there is a 'user-specified
maximum space allocation limit'. Where in the tool is
this space allocation limit specified by the user? I
could not locate it.

TIA
Raquel.



__________________________________________________
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

Raquel Rodriguez

Re: IBM DB2 Automation tool question
(in response to Mark Vickers)
Thanks Mark; you are correct. I was not involved with
setting this up and hence find it difficult to find
this kind of stuff.

Regards,
Raquel.

--- "Vickers, Mark" <[login to unmask email]> wrote:

> Raquel,
> I am just setting up the tool myself, so I am not a
> fundi by any stretch of
> the imagination.
> I am making the assumption this is workfile space
> and the only setting I
> found is in:
> SETUP > 3:DB2 Shared Profile Support:
> Max Primary Space Allocation ==> 000300 (1-999999)
> C (Trks/Cyls/Mbytes)
> F1 yields:
> Limits the amount of space that can be allocated for
> a primary allocation.
> Valid values can be specified in tracks, cylinders,
> or megabytes.
>
>
> I have just tested a fairly large reorg (13GB for TS
> & IX's) and used 300
> cylinders and it worked fine.
>
> Mark.
>
> -----Original Message-----
> From: Raquel Rodriguez
> [mailto:[login to unmask email]
> Sent: Thursday, December 02, 2004 12:00 PM
> To: [login to unmask email]
> Subject: IBM DB2 Automation tool question
>
> Am receiving warning code BCTB141W when generating
> Reorgs by IBM's "DB2 Automation Tool". Google has
> following to say:
>
> BCTB141W: space_type creator|database space_name
> partition_number Prime and Secd Space necessary for
> allocation have been truncated to user specified qty
>
> Explanation: The listed object's primary and
> secondary
> allocations were truncated due to the user-specified
> maximum space allocation limits.
>
> User Response: The job will probably fail due to
> lack
> of space. Re-evaluate your maximum space quantity
> allocations.
>
> So, as per the message, there is a 'user-specified
> maximum space allocation limit'. Where in the tool
> is
> this space allocation limit specified by the user? I
> could not locate it.
>
> TIA
> Raquel.
>
>
>
> __________________________________________________
> 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
>


__________________________________________________
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