DB2 Platinum LOADS

Lizette Koehler

DB2 Platinum LOADS
Is there a way to setup platinum tool so it does not require the DEL/DEF at the beginning of its process? We are having issues when the data base is migrated and it takes hours to recall due to its size.

Is there a way to do an HDEL and then have platinum do the def/load function?

Thanks.


Lizette

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

Re: DB2 Platinum LOADS
(in response to Lizette Koehler)
If you are talking about FastLoad, including the keyword "SPACE-DEFN NO"
will prevent it from reallocating the underlying files if they are
present.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Lizette Koehler
Sent: Monday, January 15, 2007 11:09 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 Platinum LOADS

Is there a way to setup platinum tool so it does not require the DEL/DEF
at the beginning of its process? We are having issues when the data
base is migrated and it takes hours to recall due to its size.

Is there a way to do an HDEL and then have platinum do the def/load
function?

Thanks.


Lizette

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

Phil Grainger

Re: DB2 Platinum LOADS
(in response to David Simpson)
Specifying SPACE-DEFN NO will indeed stop Fast Load from deleting and
redefining the datasets, but Lizette will still have to wait for them
all to be recalled.

I think what she is asking for is for Fast Load to do an HDELETE/Define
instead of a Delete/Define

This is currently not supported, however if you do an HDELETE (through
ISPF 3.4 perhaps) and then run Fast Load with SPACE-DEFN YES, then it
should NOT fail just because the datasets are missing - it will just
allocate new ones, which I think is what is needed here. To quote the
manual "For empty or non-existent VSAM data sets, the DB2 database
definition is used to determine the information needed" and "If the data
set is
not present, you must set SPACE-DEFN to YES or use overrides (the
tablespace or indexspace must be STOGROUP-defined)."

Hope this helps

Phil Grainger
CA
Product Manager
Phone: +44 (0)161 929 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Simpson, David
Sent: 15 January 2007 17:35
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 Platinum LOADS

If you are talking about FastLoad, including the keyword "SPACE-DEFN NO"
will prevent it from reallocating the underlying files if they are
present.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Lizette Koehler
Sent: Monday, January 15, 2007 11:09 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 Platinum LOADS

Is there a way to setup platinum tool so it does not require the DEL/DEF
at the beginning of its process? We are having issues when the data
base is migrated and it takes hours to recall due to its size.

Is there a way to do an HDEL and then have platinum do the def/load
function?

Thanks.


Lizette

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

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