View previous topic :: View next topic
|
Author |
Message |
Richa Jain
New User
Joined: 18 Mar 2008 Posts: 35 Location: Gurgaon
|
|
|
|
I want to upload data into DB2 table using FILE-AID option 3.7.2
My load dataset contains approx 100,000 records. When I'm trying to load data into the table using FILE-AID, I'm getting an error: Unavailable resource.
I have split the load file into 3 files. Each file contains 35,000 records. I am able to load the data into table using split files.
Now, I need to load 1,800,000 records into table. Splitting file and loading into table will take lot of time.
Is there any default setting which I need to set in FILE-AID so that I will be able to upload huge data?
Thanks |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
I never used FileAid for this activity, option (3.7.2) at my shops maps to
Code: |
VTOC - Display and process datasets on a volume(s) |
..
If you tell the descriptions of options used - I might try it my end... |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hi Anuj,
It is File-AID for DB2.
Code: |
File-AID for DB2 - 5.0 ------ Primary Option Menu -----------------------------
OPTION ===>
0 DEFAULTS and USER PARMS USERID - GNANAS
1 BROWSE TIME - 08:09
2 EDIT TERMINAL - 3278
3 UTILITIES PF KEYS - 24
3.1 - Object Administration DB2 SSID ===> XXXX
3.2 - Create, Model, Drop, Alter DB2 Objects
3.3 - Copy Rows Between Tables
3.4 - Object List Processing
3.5 - SQL Command Manager
3.6 - Display, Grant or Revoke DB2 Privileges
3.7 - Extract and Load Tables
3.8 - DBA-XPERT Column Impact Analysis
3.9 - Batch Execute SQL with Auto-COMMIT Processing
4 SQL ANALYSIS - SQL Development and Analysis
5 PRINT - Print table Data or Audit Trail
6 RELATIONSHIPS - Relationship Facilitator
R File-AID/RDX - Transfer to File-AID/Related Data XPERT
XT XPEDITER - Transfer to XPEDITER
T TUTORIAL - Display information about File-AID for DB2
C CHANGES - Display summary of File-AID for DB2 changes
X EXIT - Exit File-AID for DB2
Copyright (c) 1989 - 2008 Compuware Corporation. All Rights Reserved.
Unpublished - rights reserved under the Copyright Laws of the United States. |
At 3.7
Code: |
File-AID for DB2 -------------- Extract/Load Menu -----------------------------
OPTION ===> SSID ===> XXXX
1 - Extract from a Table to a dataset
2 - Load from a dataset to a Table
3 - Extract and Load |
Sorry, I'm not allowed to use this option here. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Hello,
We have faced the same issue a couple of times. But dint have the patience to figure out the actual reason. We used the BMC Load utility instead whenever we found issues with FA-Load. If you have any other DB2 load utility, you could give a try. BTW, Out of the below options, which one are you using?
Code: |
File-AID for DB2 - LOAD table - XXXXXX.TABLE_2
COMMAND ===> Scroll ===> CSR
SSID: XXXX
Specify Processing Option:
Processing Mode ===> 1 (1 = Online, 2 = Batch)
Specify Load Processing Option (select one) :
_ Add (Discard Duplicate Keys)
_ Add (Replace Duplicate Keys)
_ Delete ALL Existing Data and Add New Data
_ Add New Data to Empty Table
|
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
It is File-AID for DB2. |
Sorry, I don't have this option installed at my shop...
Ad |
|
Back to top |
|
|
sai_sridar_s
New User
Joined: 14 Nov 2006 Posts: 5
|
|
|
|
Hi,
Try running as batch instead of online...
Hope this helps..
Sai Sridar S
Always Be Happy! |
|
Back to top |
|
|
|