Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Question Unanswered: WARNING! Logical log

    Hello:

    I need some help, I am having this message on the online.log file

    WARNING! Logical log layout may cause Dynamic Server to get into
    a locked state. Recommended smallest logical log size
    is 2 times maximum concurrent user threads.

    What is wrong? do i need to change the configuration?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    You need to add extra logical logs, you probably have not enough logical log space available. You can add logical logs by doing:
    onparams -a -d <dbspace> -s <size_in_kb>
    If your version is 9.21 or lower you will have to do this in quiescent mode and create a level-0 backup before the logs are available. In 9.30 and beyond this command can be given online.

    Hope this helps,

    Rob Prop

  3. #3
    Join Date
    Apr 2004
    Posts
    12
    Thanks Rob

    I have 7.31 , I do not have a dbspace for logical logs , Do I need to added to the rootdbspace?
    GB

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    I always recommend putting the logical logs in a seperate dbspace. I don't know how big your system is, but let's say you need 20MB of logical log space (5 logs of approximately 4 MB). I don't know how familiar you are with IDS but here an example:

    Step 0: Check LOGSMAX onconfig parameter, it ust be 5 higher as the numbver of logical logs now available (onstat -l). If this is not the case, raise this parameter and restart engine.

    Step 1. Create the file/device
    In windows create an empty file
    In unix/linux touch an empty file or define a raw device, make it owner and group informix and permissions 660.

    Step 2: Create the dbspace throught the dos box in the Informix start group / telnet
    onspaces -c -d llogdbs -p <path+filename step1> -o 0 -s 20053

    Step 3: Go to quiescent mode
    onmode -u

    Step 4: Create more logical logs
    5x onparams -a -d llogdbs -s 4000

    Step 5: Go back to online mode
    onmode -m

    Step 6: Make level 0 archive
    ontaps -s -L 0 or onbar -b <-w>
    depending on the used backup tool

    Hope this helps,

    Rob Prop

  5. #5
    Join Date
    Apr 2004
    Posts
    12
    Thanks Rob for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •