SEO

Folks,

I am trying to debug a problem at client site, their DBA is on vacation.

I am having problem with one of the database where I frequently get
SQLCODE -964. I have an application that loads the data into the database
from a file. I run this application against two databases, but in one
of the database I keep getting -964. The application would commit data
after 5000 inserts, I reduced it to 1000 but still get same error.

No one is using the database while I am loading the data.

These are logfile parameters for database A where I do not have problem:

Log file size (4KB) (LOGFILSIZ) = 2000
Number of primary log files (LOGPRIMARY) = 5
Number of secondary log files (LOGSECOND) = 2


These are logfile parameters for database B where I get -964:

Log file size (4KB) (LOGFILSIZ) = 2000
Number of primary log files (LOGPRIMARY) = 10
Number of secondary log files (LOGSECOND) = 5


As you can see database B has twice the number of logfiles, yet I am getting
-964. The only difference between the two is that in database B the
LOGARCHMETH1 is TSM. Could this cause problems?

First log archive method (LOGARCHMETH1) = TSM
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
Vendor options (VENDOROPT) =


but LOGRETAIN is OFF.


Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF



--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: NoJunkMailshah@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.