Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Question Unanswered: Health Center recommendations makes bad scripts?

    If I follow the Health Center's recommendations on Reorgs and allow it to create a scheduled job to perform reorgs it actually seems to write crap scrips for them.

    Code:
    CONNECT TO <DBname>;
    REORG TABLE <Tablename>;
    CONNECT RESET;
    Which obviously gives a SQL0104N on the connect statement.

    Is it me or DB2? I'm on 8.2 for Windows patched to 11.
    What gives?

  2. #2
    Join Date
    Jul 2004
    Posts
    306
    OK I'm feeling a little stupid, I mistyped the code :/

    It actually writes:
    Code:
    CONNECT TO DATABASE <DBname>;
    REORG TABLE <Tablename>;
    CONNECT RESET;
    The addition of the word DATABASE being the problem...

Posting Permissions

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