Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    70

    Unanswered: SQL1227N - db2look to import statistics from a DB to another

    hello

    I would like to import the statistics of the prod-Database to the Test-Database.
    The DB2 version of the Production is 8.1 FP 11 under HP-UX 11.23
    The DB2 version of the Test-DB is 8.1 FP 14 under HP-UX 11.23

    I have generated the DDL's using "db2look -m" on the production, and try now to run these DDL's again the Test-Database.

    Unfortunately for some tables I receive the error message:
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>
    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL
    processing it returned:
    SQL1227N The catalog statistic "100 1885 135 1857 165 1782 180 1698 255 1504 285 13" for column "PAGE_FETCH_PAIRS" is out of
    range for its target column, has an invalid format, or is inconsistent in relation to some other statistic. Reason Code = "4". SQLSTATE=23521
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>

    I am not sure what I can do.
    Could someone help?


    Thanks a lot in advance
    Best regard
    Renaud

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can either skip this particular statistic or edit it to meet the requirements. Looking up what the reason code 4 means in the description of SQL1227N may give you more details.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2012
    Posts
    70
    Hello n_i

    thanks a lot for your reply.

    In fact I wouldn't like to skip this statistics.
    from the error message:
    The catalog statistic "100 1885 135 1857 165 1782 180 1698 255 1504 285 13" for column "PAGE_FETCH_PAIRS" is out of range for its target column.


    I took a look at the reason code 4:
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>
    4 Buffer size entries of PAGE_FETCH_PAIRS must be ascending in
    value. Also, for 32-bit instances, any buffer size value in a
    PAGE_FETCH_PAIRS entry cannot be greater than the number of pages
    in the table or 524287, whichever is lower. For 64-bit instances,
    any buffer size value in a PAGE_FETCH_PAIRS entry cannot be
    greater than the number of pages in the table or 2147483674.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>

    I don't understand why the PAGE_FETCH_PAIRS is not correct, and I am not sure how I can modify it without creating inconsistencies ot new issues.

    Thanks and regards
    Renaud

Posting Permissions

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