Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007

    Question Unanswered: Maximum possible records in a Cursor


    We are having a stored proc which uses a cursor to return the records of a table. The table contains 3.5 Million records.

    Can I know what is the maximum possible records we can return from a cursor..?


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    The number of rows is limited by your storage and underlying tables. The manual says you can have 128 *10^10 rows per database partition in a non-partitioned table and the same number of rows in a table partition of a partitioned table per database partition. If you do cross joins, I guess your limiting factors will not be DB2 but rather storage and the speed with which your application can process the rows.

    p.s: 3.5 million rows is not a lot and I wouldn't start to worry about it.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Nov 2007
    i dont think there is a limit on the number of records but rather see your dba as they are the one who can help u in this regard as they are the pain creaters and pain killers

Posting Permissions

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