Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SAVE DATA AS to concatenate multiple tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Tue Jun 17, 2008 8:29 pm    Post subject: SAVE DATA AS to concatenate multiple tables
Reply with quote

hi,

I have used SAVE DATA AS commmand to create a separate two test table.

Table is created as follows,

SCHEMANAME.TABNAME1
SCHEMANAME.TABNAME2

1)Now is it possible to concatenate these two tables?...
2)Do we have any utility for that?
3)If each table has more than 50 lakhs records, is it possible to concatenate 25 tablse at a time.

could any body help me with this?

Thanks,
Nagendran.R
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 17, 2008 9:49 pm    Post subject:
Reply with quote

Hello,

Where did you "save" these "tables"?

What is your meaning of "concatenate" for these tables? Concatenation is (typically) used for sequential (qsam) processing rather than database table processing.

It you clarify what you have and what you want to do, someone may have suggestions.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Tue Jun 17, 2008 10:11 pm    Post subject: Reply to: SAVE DATA AS to concatenate multiple tables
Reply with quote

Hi,

We are having a DB2 table in our system, we have set of files
needs to be loaded(nearly 5 crores) to this table.
We need to do this with in couple of days.....

I am having a suggestion like we can use SAVE DATA AS
command to create our own table......

so if we create 10 set of tables, then load each file into this ten table.
Till now it is possible.....

Is there any utility is available to concatenate all these tables and to
put it in Master table.

I dont know whether above will work or not????

Please let me know your suggestions.


Thanks,
Nagendran.R
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 17, 2008 10:48 pm    Post subject:
Reply with quote

Hello,

Quote:
Is there any utility is available to concatenate all these tables and to put it in Master table.
Not that i'm aware of. . .

If the data is places into these "new" tables and then read/loaded into the master table, the overhead will almost surely be far greater than loading directly in the first place.

Does this "nearly 5 crores" mean 50 million (many people here do not know those units of measure)? What kind of data does the table contain?
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Tue Jun 17, 2008 11:00 pm    Post subject: Reply to: SAVE DATA AS to concatenate multiple tables
Reply with quote

Hi,

I have to load record from sequential file to DB2.

We already written one program to load record into tables.

We have created set of jobs to load these records, when we run the jobs
parallely it got abends SQL code -904 deadloack.

So we dont have any other options, we are submitting one job at a time...

Is there any other way to identify the reason for the deadlock?

When we started the load, the records are loaded very fast, now
again the performace become very low.

If we use load utility will it give better performace than this?

Thanks,
Nagendran.R
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 17, 2008 11:25 pm    Post subject:
Reply with quote

Hello,

Quote:
If we use load utility will it give better performace than this?
Using the load utility will perform exponentially faster.

In your program you are probably doing an INSERT for each row - this will run slower as it continues. The higher the volume, the worse it will run.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us