Skip to Content
0
Nov 08, 2012 at 11:35 AM

Error on DB2 9.7 in linux for SAP solution manager 7.1

67 Views

Dear All,

We are facing the error on Dataase partions ahile installation with SAP.

CREATE DATABASE PARTITION GROUP NGRP_FACT_KSM ON DBPARTITIONNUMS( 0 )

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL1762N Unable to connect to database because there is not enough space to

allocate active log files. SQLSTATE=08004

find the o/p for db2 get db cfg for KSM | grep -i log

solman:db2ksm 51> db2 get db cfg for KSM | grep -i log

Log retain for recovery status = NO

User exit for logging status = NO

Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2560

Log buffer size (4KB) (LOGBUFSZ) = 512

Log file size (4KB) (LOGFILSIZ) = 16380

Number of primary log files (LOGPRIMARY) = 60

Number of secondary log files (LOGSECOND) = 0

Changed path to log files (NEWLOGPATH) =

Path to log files = /db2/KSM/log_dir/NODE0000/

Overflow log path (OVERFLOWLOGPATH) =

Mirror log path (MIRRORLOGPATH) =

First active log file =

Block log on disk full (BLK_LOG_DSK_FUL) = NO

Block non logged operations (BLOCKNONLOGGED) = NO

Percent max primary log space by transaction (MAX_LOG) = 0

Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

Percent log file reclaimed before soft chckpt (SOFTMAX) = 200

Log retain for recovery enabled (LOGRETAIN) = OFF

User exit for logging enabled (USEREXIT) = OFF

HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC

First log archive method (LOGARCHMETH1) = OFF

Options for logarchmeth1 (LOGARCHOPT1) =

Second log archive method (LOGARCHMETH2) = OFF

Options for logarchmeth2 (LOGARCHOPT2) =

Failover log archive path (FAILARCHPATH) =

Number of log archive retries on error (NUMARCHRETRY) = 5

Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20

Log pages during index build (LOGINDEXBUILD) = OFF

I tried to change the parameters in db2 ut i am again facing error

solman:db2ksm 53> db2 connect to KSM

SQL1762N Unable to connect to database because there is not enough space to

allocate active log files. SQLSTATE=08004

Pls guide me how to continue with this check space in server lot of spaces are avilale

THanks,

Thamu.