Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2005

Tip: Looking for answers? Try searching our database.

Problems creating database using scripts provided by LMS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Harlin - 31 Oct 2005 16:55 GMT
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 - 31 Oct 2005 17:03 GMT
> Hi,
>
[quoted text clipped - 12 lines]
> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.