IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

upload data into table using FILE-AID


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
Richa Jain

New User


Joined: 18 Mar 2008
Posts: 35
Location: Gurgaon

PostPosted: Tue Feb 10, 2009 5:03 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Tue Feb 10, 2009 7:20 pm
Reply with quote

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)
.. icon_neutral.gif

If you tell the descriptions of options used - I might try it my end... icon_smile.gif
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Tue Feb 10, 2009 7:43 pm
Reply with quote

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. icon_sad.gif
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Feb 10, 2009 8:06 pm
Reply with quote

Hello,

We have faced the same issue a couple of times. But dint have the patience to figure out the actual reason. icon_biggrin.gif 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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Feb 11, 2009 12:13 pm
Reply with quote

Quote:
It is File-AID for DB2.
Sorry, I don't have this option installed at my shop... icon_cry.gif

Ad
Back to top
View user's profile Send private message
sai_sridar_s

New User


Joined: 14 Nov 2006
Posts: 5

PostPosted: Wed Feb 11, 2009 4:25 pm
Reply with quote

Hi,

Try running as batch instead of online...

Hope this helps..

Sai Sridar S
Always Be Happy!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Load new table with Old unload - DB2 DB2 6
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top