Increase LOGSECOND

[b***@yahoo.com]

I am at the db2 command prompt and trying to increase the size of my transaction log. I can't figure it out. Here's what I get:

db2 => update dbm cfg using LOGSECOND=100
SQL0104N An unexpected token "LOGSECOND=100" was found following "USING".
Expected tokens may include: "AGENTPRI". SQLSTATE=42601


Can someone help me? Am I typing the command wrong?

[Andreas Kannegiesser]

first LOGSECOND is a database parameter and not a database manager parameter.
so u should connect to the database and then use the command UPDATE DB CFG...

second, the syntax should be without the "=" like so:

db2==>UPDATE DB CFG USING LOGSECOND 100

or alternatively

db2==>UPDATE DB CFG FOR <db_name> USING LOGSECOND 100


good luck
aka.

[b***@yahoo.com]

That worked. Thank you very much. =)