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

SQL Performance issue


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Fri Sep 12, 2008 11:17 am
Reply with quote

Hi,

I have a table that has to hold 18 months data in it. There are 9 columns and Max Rec length=41. The columns of the table are given below.
1. DATE
2. DEPTARTMENT
3. CLASS
4. ITEM
5. LOCATION
6. TYPE
7. AMOUNT
8. QUANTITY
9. TIMESTAMP

The table is partitioned on Column 1 till 5 as such there are 545 partitions. The table is loaded with utmost 20million rows using IBM LOAD Utility everyday.

Now, there is a SQL to be run that uses 3 tables other than this table that include conditions on columns 1 till 6. The SQl is ending with -905 error.

Could someone please advise me on what can be done to solve this issue.

Thanks,
KJ
Back to top
View user's profile Send private message
abhishekmdwivedi

New User


Joined: 22 Aug 2006
Posts: 95
Location: india

PostPosted: Fri Sep 12, 2008 11:58 am
Reply with quote

Please have a look at the below link :


Type_Description_Here
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.codes/n905.htm?resultof=%22%2d%39%30%35%22%20%22%39%30%35%22%20
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Fri Sep 12, 2008 1:57 pm
Reply with quote

But this does not solve my issue.

Thanks,
KJ
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri Sep 12, 2008 3:16 pm
Reply with quote

Run an explain on your query and see which part of your SQL is taking the most time .... chk for proper index usages and proper where clauses ....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts exploiting Z16 performance PL/I & Assembler 2
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
No new posts Facing ABM3 issue! CICS 3
No new posts JOIN STATEMENT PERFORMANCE. DFSORT/ICETOOL 12
Search our Forums:

Back to Top