datastage installation issue: SQL1762N Unable to connect

[abdulgani]

Hi All,

While installing IBM Information Server 8.x (datastage 8.x) the installation failed with the following error, can any one advise me how to increase / limit allocate active log files while installation.

Syed.

[db2admin@DXEDWCFSO01] /opt/IBM/db2 > df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 2097152 1767408 16% 3862 1% /
/dev/hd2 3080192 361372 89% 54963 8% /usr
/dev/hd9var 262144 146816 44% 1364 3% /var
/dev/hd3 2949120 1459396 51% 4113 1% /tmp
/dev/hd1 1835008 762236 59% 626 1% /home
/proc - - - - - /proc
/dev/hd10opt 1245184 923084 26% 2706 1% /opt
/dev/lv02 655360 634116 4% 21 1% /audit
/dev/appllv 31457280 8785688 73% 147179 2% /app
/dev/datalv 10485760 1065332 90% 14197 1% /data
[db2admin@DXEDWCFSO01] /opt/IBM/db2 > df .
Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/hd10opt 2490368 1846168 26% 2706 1% /opt
[db2admin@DXEDWCFSO01] /opt/IBM/db2 >



04/27/2008 17:21:01 UPDATE DATABASE CONFIGURATION FOR db2gdwfl USING LOGSECOND 200
04/27/2008 17:21:01 DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

04/27/2008 17:21:01 CONNECT TO db2gdwfl
04/27/2008 17:21:09 SQL1762N Unable to connect to database because there is not enough space to allocate active log files. SQLSTATE=08004

04/27/2008 17:21:09 GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONN
ECT ON DATABASE TO USER db2admin
04/27/2008 17:21:09 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During
SQL processing it returned:
04/27/2008 17:21:09 SQL1024N A database connection does not exist. SQLSTATE=08003

04/27/2008 17:21:09 COMMIT WORK
04/27/2008 17:21:09 SQL1024N A database connection does not exist. SQLSTATE=08003

04/27/2008 17:21:09 ALTER BUFFERPOOL IBMDEFAULTBP IMMEDIATE SIZE 2000 AUTOMATIC
04/27/2008 17:21:09 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During
SQL processing it returned:
04/27/2008 17:21:09 SQL1024N A database connection does not exist. SQLSTATE=08003

[ArndW]

This is not a DataStage, but a DB2 problem. The relevant DB2 settings can be lookup up at LOGPRIMARY and/or LOGFILSIZ