User Profile

Collapse

Profile Sidebar

Collapse
tsaul
tsaul
Last Activity: Jun 30 '08, 05:26 AM
Joined: Jan 31 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • tsaul
    replied to DB2 Performance tunning
    in DB2
    What DB2 environment do you mean? LUW or z/OS. I'm mostly z/OS, so I will give that view.
    In z/OS you generally specify the Tablespace when defining the Table. You can also find by Selecting from SYSIBM.SYSTABLE S there is a column TSNAME.

    As to improving INSERT performance, check your Freespace and Freepage. Also how many Indexes are defined. Each Index needs to be updated for every INSERT. In DB2 V8 and V9 there are Muliple...
    See more | Go to post

    Leave a comment:


  • tsaul
    replied to IMS to DB2 migration
    in DB2
    You would be better posting to DB2-L, I think the IMS list might get upset.
    You can Subscribe (or search archives) at
    http://www.idugdb2-l.org/archives/db2-l.html (Join or Leave) and
    send messages to DB2-L@www.idugdb2-l.org
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...