Health Center recommendations makes bad scripts?

meehange · #1 (**permalink**) 07-19-06, 01:09

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?

meehange · #2 (**permalink**) 07-24-06, 21:55

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...

Internet Services

Web Development

Digital Marketing

Consumer Tech