Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    2

    Unanswered: How to regenerate view (AIX/DB2)

    Hi,

    I want to drop an expression from the generated table column in DB2 (AIX) v8.1. I am getting the following error:

    56098(-727)[IBM][CLI Driver][DB2/AIX64] SQL0727N An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-101", SQLSTATE "54001" and message tokens "". SQLSTATE=56098

    >> Type 3 in documentation implies that there is one or more view which needs to be regenerated.

    Can somebody tell me how to regenerate the view on DB2/AIX?

    <<
    Additionally I googled and found the following code
    ALTER VIEW view REGENERATE;
    But it did not work on DB2/AIX as it strangely works (?) on z/OS2 only
    >>

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What's important here is SQLCODE "-101": "Statement too long or too complex". Try increasing the value of the STMTHEAP database configuration parameter.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jun 2007
    Posts
    2

    Thumbs up

    Hi,

    I could not find better way of doing it. After spending hours I came to the conclusion that dropping and recreating the views is the only feasible solurion. So I dropped the views, which were causing problems, then I dropped the expression of generated column and then recreated views. And VOILA it worked just fine

    Thanks everyone for your suggestions.

    - AJ

Posting Permissions

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