Configuration Advisor

[nek]

Greetings,

Platform is DB2 V8.1, FP2 on W2K.

Has anyone succeeded in invoking 'Configuration Advisor' from Control
Center with DB2 running on W2K?

I tried but failed with SQL22205C if it was invoked by right-clicking
database or DBA1107E if using Tools -> Wizards -> Configuration
Advisor.

Neither db2dasdiag.log nor db2diag.log gave any useful info after
setting diaglevel=4.

Thank you.

[Knut Stolze]

nek <ne*****@hotmai l.com> wrote:

Greetings,

Platform is DB2 V8.1, FP2 on W2K.

Has anyone succeeded in invoking 'Configuration Advisor' from Control
Center with DB2 running on W2K?

I'm on 8.1.4 and the Confugration Advisor works quite fine for me.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[PM \(pm3iinc-nospam\)]

Maybe something around ports?

\system32\drive rs\etc
get admin cfg

PM

[Mick Legare]

Hi,
What DB2 product are you using? (Personal edition, Workgroup, ESE ...)

Have you tried invoking the advisor from the command line?

Example:
$ db2 connect to db
$ db2 autoconfigure apply none

Try this to start and see if you get the recommendation display screen.

Then,
$ db2 \? autoconfigure to get all the options for the command and issue
it with the "apply db and dbm" clause.

(replace $ with your favorite Windows prompt :)

Mick
nek wrote:

Greetings,

Platform is DB2 V8.1, FP2 on W2K.

Has anyone succeeded in invoking 'Configuration Advisor' from Control
Center with DB2 running on W2K?

I tried but failed with SQL22205C if it was invoked by right-clicking
database or DBA1107E if using Tools -> Wizards -> Configuration
Advisor.

Neither db2dasdiag.log nor db2diag.log gave any useful info after
setting diaglevel=4.

Thank you.

[nek]

Thanks for all the replies.

We use Workgroup edition.

I did execute 'db2 autoconfigure' successfully.

PM, regarding port (C:\winnt\syste m32\drivers\etc ), would you elorate
a bit more on this please? Here is the result of 'db2 get cfg admin':
Admin Server Configuration

Authentication Type DAS (AUTHENTICATION ) =
SERVER_ENCRYPT

DAS Administration Authority Group Name (DASADM_GROUP) =
DAS Discovery Mode (DISCOVER) = SEARCH
Name of the DB2 Server System (DB2SYSTEM) = DBSIMAGE
Java Development Kit Installation Path DAS (JDK_PATH) = D:\Program
Files\IBM\SQLLI B\\java\jdk\

Java Development Kit Installation Path DAS (JDK_64_PATH) =
DAS Code Page (DAS_CODEPAGE) = 0
DAS Territory (DAS_TERRITORY) = 0
Location of Contact List (CONTACT_HOST) =
Execute Expired Tasks (EXEC_EXP_TASK) = NO
Scheduler Mode (SCHED_ENABLE) = ON
SMTP Server (SMTP_SERVER) =

Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB
Tools Catalog Database Instance (TOOLSCAT_INST) = DB2
Tools Catalog Database Schema (TOOLSCAT_SCHEM A) = SYSTOOLS
Scheduler User ID =

Many Thanks.
Mick Legare <ml*****@no-spam-ca.ibm.com> wrote in message news:<3F******* ********@no-spam-ca.ibm.com>...

Hi,
What DB2 product are you using? (Personal edition, Workgroup, ESE ...)

Have you tried invoking the advisor from the command line?

Example:
$ db2 connect to db
$ db2 autoconfigure apply none

Try this to start and see if you get the recommendation display screen.

Then,
$ db2 \? autoconfigure to get all the options for the command and issue
it with the "apply db and dbm" clause.

(replace $ with your favorite Windows prompt :)

Mick
nek wrote:

Greetings,

Platform is DB2 V8.1, FP2 on W2K.

Has anyone succeeded in invoking 'Configuration Advisor' from Control
Center with DB2 running on W2K?

I tried but failed with SQL22205C if it was invoked by right-clicking
database or DBA1107E if using Tools -> Wizards -> Configuration
Advisor.

Neither db2dasdiag.log nor db2diag.log gave any useful info after
setting diaglevel=4.

Thank you.

[PM \(pm3iinc-nospam\)]

If it works on the command line, the communication/networking is most likely
not an issue anymore.
(unless there is something weird in the hosts, services or protocol files)

Firewall blocking port 523?
(google : iana port 523)

One thing i noticed is that if you do a db2admin stop, the wizard doesn't
work (DBA1107E) but
the command line works. If you then do a db2admin start, the wiz works.

Anybody changed any security/user settings around the das? (db2admin setid
?)
Is the admin server started? (db2admin start)

I'd check also on the java/jdk side if db2admin start doesn't resolve the
problem.

DMB CFG
(JDK_PATH)
(JAVA_HEAP_SZ)

PM

[nek]

Hi PM,

I tried to invoke 'Configure Advisor' on the TEST machine which has
the same setup as PROD machines (where I have problems), it worked. I
logged on Prod machine via 'remote desktop connection', this should
behave as though I logon directly.

I checked with Network guys who confirmed port 523(IBM-DB2) is not
blocked.

I tried to db2admin stop/start, it did not help.

The java/jdk path looks ok:
(JDK_PATH) = D:\Program Files\IBM\SQLLI B\java\jdk
(JAVA_HEAP_SZ) =512

I tried 'db2admin setid', it returned SQL1092N error.

'db2 get authorizations' shows that the logon account has 'Indirect
SYSADM' authority, I did more tests to confirm this (db2admin
stop/start, create db etc.) and they all work fine.

Here is how I resolve the problem, it could relate to the security
setting you mentioned:

(logon with the admin account)
.. db2admin stop
.. db2admin drop
.. db2admin create /user:(the admin account I use to logon W2K)
/password: (the pwd for the admin account)
.. db2admin start

Now db2cc and right click the db for 'configure Advisor', it worked!

One thing still puzzles me though, I still can not execute 'db2admin
setid' using the above admin account and pwd after all these (SQL1092N
error). Any ideas??

Thanks again for all the tips that help me narrow down the problem.


"PM \(pm3iinc-nospam\)" <PM(pm3iinc-nospam)@sympati co.ca> wrote in message news:<Dj******* *************@n ews20.bellgloba l.com>...

If it works on the command line, the communication/networking is most likely
not an issue anymore.
(unless there is something weird in the hosts, services or protocol files)

Firewall blocking port 523?
(google : iana port 523)

One thing i noticed is that if you do a db2admin stop, the wizard doesn't
work (DBA1107E) but
the command line works. If you then do a db2admin start, the wiz works.

Anybody changed any security/user settings around the das? (db2admin setid
?)
Is the admin server started? (db2admin start)

I'd check also on the java/jdk side if db2admin start doesn't resolve the
problem.

DMB CFG
(JDK_PATH)
(JAVA_HEAP_SZ)

PM