|
View previous topic :: View next topic
|
| Author |
Message |
Nagendran
New User
Joined: 24 Jan 2007
Posts: 89
Location: USA
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Nagendran
New User
Joined: 24 Jan 2007
Posts: 89
Location: USA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Nagendran
New User
Joined: 24 Jan 2007
Posts: 89
Location: USA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
|
|
