469,360 Members | 1,728 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,360 developers. It's quick & easy.

Problems creating database using scripts provided by LMS

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

Nov 12 '05 #1
1 2468
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?
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Dim St Thomas | last post: by
55 posts views Thread by drhowarddrfine | last post: by
6 posts views Thread by Jeff | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.