REORGCHK question

KATHY JONES

REORGCHK question
Running Enterprise DB2 7.2 on Windows NT

I am trying to set up a script to run REORGCHK on certain tables. I have encountered two problems.

1. When I set the script up as 'REORGCHK CURRENT STATISTICS ON TABLE ALL;' When it ran, it gave me an error on the word ALL. According to DB2 Universal Database V7.1 Database ADministration Certification Guide, that is a valid option.

2. The first line in my script is the connect to SASIXP user xxx using xxx. When I changed the script to only REORGCHK certain tables, it is losing my password and not connecting to the database.

Any suggestions to what I am doing wrong?

The 1st script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table all;
disconnect sasixp;

The second script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table sasi.aenr1201;
reorgchk current statistics on table sasi.aenr1202;
reorgchk current statistics on table sasi.aenr1203;
reorgchk current statistics on table sasi.aenr1204;
reorgchk current statistics on table sasi.aenr1205;
disconnect sasixp;

The error I receive is: connect to SASIXP user jonesks using
SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004






Kathy Jones
Central Information Services
Clark County School District
Senior Database Analyst
NT DB2 DBA
702-799-5040 x366
[login to unmask email]



Jeremy Schleicher

Re: REORGCHK question
(in response to KATHY JONES)
what are you running your script in? Your syntax looks good to me.



From: KATHY JONES <[login to unmask email]>@RYCI.COM on 01/03/2002 03:19
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: REORGCHK question


Running Enterprise DB2 7.2 on Windows NT

I am trying to set up a script to run REORGCHK on certain tables. I have
encountered two problems.

1. When I set the script up as 'REORGCHK CURRENT STATISTICS ON TABLE ALL;'
When it ran, it gave me an error on the word ALL. According to DB2
Universal Database V7.1 Database ADministration Certification Guide, that
is a valid option.

2. The first line in my script is the connect to SASIXP user xxx using
xxx. When I changed the script to only REORGCHK certain tables, it is
losing my password and not connecting to the database.

Any suggestions to what I am doing wrong?

The 1st script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table all;
disconnect sasixp;

The second script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table sasi.aenr1201;
reorgchk current statistics on table sasi.aenr1202;
reorgchk current statistics on table sasi.aenr1203;
reorgchk current statistics on table sasi.aenr1204;
reorgchk current statistics on table sasi.aenr1205;
disconnect sasixp;

The error I receive is: connect to SASIXP user jonesks using
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004






Kathy Jones
Central Information Services
Clark County School District
Senior Database Analyst
NT DB2 DBA
702-799-5040 x366
[login to unmask email]








KATHY JONES

Re: REORGCHK question
(in response to Jeremy Schleicher)
I was running in the script window with a run now - should I run it in command center instead?

>>> [login to unmask email] 01/03/02 02:09PM >>>
what are you running your script in? Your syntax looks good to me.



From: KATHY JONES <[login to unmask email]>@RYCI.COM on 01/03/2002 03:19
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: REORGCHK question


Running Enterprise DB2 7.2 on Windows NT

I am trying to set up a script to run REORGCHK on certain tables. I have
encountered two problems.

1. When I set the script up as 'REORGCHK CURRENT STATISTICS ON TABLE ALL;'
When it ran, it gave me an error on the word ALL. According to DB2
Universal Database V7.1 Database ADministration Certification Guide, that
is a valid option.

2. The first line in my script is the connect to SASIXP user xxx using
xxx. When I changed the script to only REORGCHK certain tables, it is
losing my password and not connecting to the database.

Any suggestions to what I am doing wrong?

The 1st script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table all;
disconnect sasixp;

The second script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table sasi.aenr1201;
reorgchk current statistics on table sasi.aenr1202;
reorgchk current statistics on table sasi.aenr1203;
reorgchk current statistics on table sasi.aenr1204;
reorgchk current statistics on table sasi.aenr1205;
disconnect sasixp;

The error I receive is: connect to SASIXP user jonesks using
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004






Kathy Jones
Central Information Services
Clark County School District
Senior Database Analyst
NT DB2 DBA
702-799-5040 x366
[login to unmask email]











Russell Collins

Re: REORGCHK question
(in response to KATHY JONES)
Here is what I have come up with. If you run the command in the command
center under INTERACTIVE, it will work. I have not been able to get it to
work under SCRIPT yet. I don't know how to create a script that will run
successfully in the batch process.

Note:
You can run the reorgchk command by just using "reorgchk". This will run
reorgchk for the default schema only. Example: I log in as russell, the
check will only check those that are under the schema name russell. If you
want all of the tables, regardless of schema name then you will need the
extra arguments after the command.

I hope this helps

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
KATHY JONES
Sent: Thursday, January 03, 2002 4:23 PM
To: [login to unmask email]
Subject: Re: REORGCHK question


I was running in the script window with a run now - should I run it in
command center instead?

>>> [login to unmask email] 01/03/02 02:09PM >>>
what are you running your script in? Your syntax looks good to me.



From: KATHY JONES <[login to unmask email]>@RYCI.COM on 01/03/2002 03:19
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: REORGCHK question


Running Enterprise DB2 7.2 on Windows NT

I am trying to set up a script to run REORGCHK on certain tables. I have
encountered two problems.

1. When I set the script up as 'REORGCHK CURRENT STATISTICS ON TABLE ALL;'
When it ran, it gave me an error on the word ALL. According to DB2
Universal Database V7.1 Database ADministration Certification Guide, that
is a valid option.

2. The first line in my script is the connect to SASIXP user xxx using
xxx. When I changed the script to only REORGCHK certain tables, it is
losing my password and not connecting to the database.

Any suggestions to what I am doing wrong?

The 1st script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table all;
disconnect sasixp;

The second script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table sasi.aenr1201;
reorgchk current statistics on table sasi.aenr1202;
reorgchk current statistics on table sasi.aenr1203;
reorgchk current statistics on table sasi.aenr1204;
reorgchk current statistics on table sasi.aenr1205;
disconnect sasixp;

The error I receive is: connect to SASIXP user jonesks using
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004






Kathy Jones
Central Information Services
Clark County School District
Senior Database Analyst
NT DB2 DBA
702-799-5040 x366
[login to unmask email]

















Jeremy Schleicher

Re: REORGCHK question
(in response to Russell Collins)
Yeah try that. I always run it there.



From: KATHY JONES <[login to unmask email]>@RYCI.COM on 01/03/2002 04:22
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: REORGCHK question


I was running in the script window with a run now - should I run it in
command center instead?

>>> [login to unmask email] 01/03/02 02:09PM >>>
what are you running your script in? Your syntax looks good to me.



From: KATHY JONES <[login to unmask email]>@RYCI.COM on 01/03/2002 03:19
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: REORGCHK question


Running Enterprise DB2 7.2 on Windows NT

I am trying to set up a script to run REORGCHK on certain tables. I have
encountered two problems.

1. When I set the script up as 'REORGCHK CURRENT STATISTICS ON TABLE ALL;'
When it ran, it gave me an error on the word ALL. According to DB2
Universal Database V7.1 Database ADministration Certification Guide, that
is a valid option.

2. The first line in my script is the connect to SASIXP user xxx using
xxx. When I changed the script to only REORGCHK certain tables, it is
losing my password and not connecting to the database.

Any suggestions to what I am doing wrong?

The 1st script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table all;
disconnect sasixp;

The second script looks like this:
connect to SASIXP user jonesks using xxxxxxxx;
reorgchk current statistics on table sasi.aenr1201;
reorgchk current statistics on table sasi.aenr1202;
reorgchk current statistics on table sasi.aenr1203;
reorgchk current statistics on table sasi.aenr1204;
reorgchk current statistics on table sasi.aenr1205;
disconnect sasixp;

The error I receive is: connect to SASIXP user jonesks using
SQL1403N The username and/or password supplied is incorrect.
SQLSTATE=08004






Kathy Jones
Central Information Services
Clark County School District
Senior Database Analyst
NT DB2 DBA
702-799-5040 x366
[login to unmask email]