User Profile

Collapse

Profile Sidebar

Collapse
vamsi
vamsi
Last Activity: Dec 1 '11, 04:34 AM
Joined: Nov 30 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • vamsi
    replied to Index length of in the DB2v9.
    in DB2
    Hi Rabbit,

    Thanks for the response. I had gone through this and found that it is quarter of the page size. I've declared my bufferpool as BP32K and hence I'm exepcting that it should accept a length of 8K. But it is still failing with a SQLCODE of -613.

    Thanks & Regards,
    Vamsi
    See more | Go to post

      Leave a comment:

    • vamsi
      started a topic Index length of in the DB2v9.
      in DB2

      Index length of in the DB2v9.

      Hi,

      I'm trying to create a table with a unique index consits of 5 columns with the datatypes ( VARCHAR(80), VARCHAR(144), VARCHAR(1020), VARCHAR(1020), VARCHAR(1020)). But my create table structure is failing as my primary key length is getting exceeded. But I've defined my page size as 32K. which means I can create an index with a length of 8K, but my key size is less than 8k. Can you please suggest me what could be the problem?...
      See more | Go to post
      No activity results to display
      Show More
      Working...