Problems creating database using scripts provided by LMS

[Harlin]

Hi,

I am trying to set up the database for LMS on a Linux box. This box is
running SLES 9. I am trying to run the following scripts as user:
db2inst1 :

../cr_db2db_audit.sh

and I receive the following error messages(snipped for brevity because
they are repeating errors):

+ db2 create database lsaudit on alias lsaudit using codeset UTF-8
territory US
SQL0104N An unexpected token "lsaudit" was found following "ALIAS".
Expected
tokens may include: "CATALOG". SQLSTATE=42601

+ db2 update db cfg for lsaudit using LOGBUFSZ 12
SQL1013N The database alias name or database name "LSAUDIT" could not
be
found. SQLSTATE=42705

+ db2 connect to lsaudit
SQL1013N The database alias name or database name "LSAUDIT" could not
be found

SQL0843N The server name does not specify an existing connection.
SQLSTATE=08003

I thought maybe that I should manually create the database "LSAUDIT"
and see how that works but the manual (and others) have said not to do
that -- the script is supposed to create the database itself.

Is there anything that I am missing? I have checked the LMS manual and
not been able to find anything that I have missed (though I may have).

Thanks,

Harlin Seritt

[Gert van der Kooij]

In article <11**********************@g14g2000cwa.googlegroups .com>,
ha**********@yahoo.com says...

Hi,

I am trying to set up the database for LMS on a Linux box. This box is
running SLES 9. I am trying to run the following scripts as user:
db2inst1 :

./cr_db2db_audit.sh

and I receive the following error messages(snipped for brevity because
they are repeating errors):

+ db2 create database lsaudit on alias lsaudit using codeset UTF-8
territory US
SQL0104N An unexpected token "lsaudit" was found following "ALIAS".
Expected
tokens may include: "CATALOG". SQLSTATE=42601

The 'create database' command is missing the drive/directory where you
want to place the db. It needs to be added between 'lsaudit on' and
'alias lsaudit'.
Maybe you need to specify a database location when running the script?