Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: 32 K limit on record

    Is there any way to extend this limit for a table to store > 32K Records.
    Or any work around.

    Any thoughts 'd be greatly appreciated.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can store some of the data in a BLOB or CLOB column. These data types are not actually stored in the same place as the rest of the table, and they do not make use of bufferpools for cache, so performance is not quite as fast.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by udbdb2
    Is there any way to extend this limit for a table to store > 32K Records.
    Or any work around.

    Any thoughts 'd be greatly appreciated.
    What specifically are you trying to store?

    One workaround is to use two tables and access it via a view.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •