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
 

 

SQL Performance issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: SQL Performance issue
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    Post subject: Reply to: SQL Performance issue
Reply with quote

Please have a look at the below link :


Type_Description_Here
http://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    Post subject: SQL Performance issue
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    Post subject:
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    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 BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm


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