Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Question Unanswered: Changing Logging Configuration Parameters

    i just changed the logfiles value default, 6 files into 1000 files. arcoding to IDS manual, the maximum values is 32,767 files. I did restart my db server but the server stick in "off" mode. help me please..

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please send me the 100 last lines of log file.
    Warning the 'logging' of database is not equal what log of transaction (logical logs).

    Gustavo.

  3. #3
    Join Date
    Nov 2005
    Posts
    4

    Talking tq

    thank for feedback.

    Since i got a problem to backup the logfiles so i prefered to add the number of logfiles. I assumed that i didn't need do the backup work frequently since i'hv succeed adding the large number of logfiles. By the way this is the last 100 line that you asked.

    addr len type xid id link
    f7650 92 HINSERT 5 0 f761c 100040 32a 46
    f76ac 96 ADDITEM 5 0 f7650 100040 32a 1 1 45
    f770c 52 ADDITEM 5 0 f76ac 100040 32a 2 2 4
    f7740 144 HINSERT 5 0 f770c 1000dd 418 99
    f77d0 96 ADDITEM 5 0 f7740 1000dd 418 1 1 45
    f7830 52 ADDITEM 5 0 f77d0 1000dd 418 2 2 4
    f7864 76 HINSERT 5 0 f7830 1000de 84e 30
    f78b0 56 ADDITEM 5 0 f7864 1000de 84e 6 1 6
    f78e8 52 ADDITEM 5 0 f78b0 1000de 84e 2 2 4
    f791c 76 HINSERT 5 0 f78e8 1000de 84f 30
    f7968 56 ADDITEM 5 0 f791c 1000de 84f 6 1 6
    f79a0 52 ADDITEM 5 0 f7968 1000de 84f 2 2 4
    f79d4 76 HINSERT 5 0 f79a0 1000de 850 32
    f7a20 56 ADDITEM 5 0 f79d4 1000de 850 6 1 6
    f7a58 52 ADDITEM 5 0 f7a20 1000de 850 2 2 4
    f7a8c 124 HINSERT 5 0 f7a58 1000e0 415 77
    f7b08 116 ADDITEM 5 0 f7a8c 1000e0 415 5 1 68
    f7b7c 84 ADDITEM 5 0 f7b08 1000e0 415 2 2 36

    addr len type xid id link
    f7bd0 56 HUPDAT 5 0 f7b7c 1000dd 416 0 96 96 1
    f7c08 56 HUPDAT 5 0 f7bd0 1000dd 417 0 97 97 1
    f7c40 36 COMMIT 5 0 f7c08 11/15/2005 15:20:30
    f8018 40 BEGIN 5 4 0 11/15/2005 15:20:30 17 unknown
    f8040 124 HDELETE 5 0 f8018 1000e0 415 77
    f80bc 116 DELITEM 5 0 f8040 1000e0 415 5 1 68
    f8130 84 DELITEM 5 0 f80bc 1000e0 415 2 2 36
    f8184 56 HUPDAT 5 0 f8130 1000dd 418 0 99 99 1
    f81bc 36 COMMIT 5 0 f8184 11/15/2005 15:20:30
    f9018 40 BEGIN 5 4 0 11/15/2005 15:20:30 17 unknown
    f9040 124 HINSERT 5 0 f9018 1000e0 416 77
    f90bc 116 ADDITEM 5 0 f9040 1000e0 416 5 1 68
    f9130 84 ADDITEM 5 0 f90bc 1000e0 416 2 2 36
    f9184 36 COMMIT 5 0 f9130 11/15/2005 15:20:30
    fa018 40 BEGIN 5 4 0 11/15/2005 15:20:30 17 unknown
    fa040 96 HINSERT 5 0 fa018 1000e3 202 51
    fa0a0 80 ADDITEM 5 0 fa040 1000e3 202 1 1 32
    fa0f0 36 COMMIT 5 0 fa0a0 11/15/2005 15:20:30

    addr len type xid id link
    fb018 40 BEGIN 5 4 0 11/15/2005 15:20:30 17 unknown
    fb040 96 HINSERT 5 0 fb018 1000e3 203 51
    fb0a0 80 ADDITEM 5 0 fb040 1000e3 203 1 1 32
    fb0f0 56 HUPDAT 5 0 fb0a0 1000dd 410 0 97 97 1
    fb128 56 HUPDAT 5 0 fb0f0 1000dd 411 0 97 97 1
    fb160 56 HUPDAT 5 0 fb128 1000dd 412 0 97 97 1
    fb198 56 HUPDAT 5 0 fb160 1000dd 413 0 99 99 1
    fb1d0 56 HUPDAT 5 0 fb198 1000dd 414 0 98 98 1
    fb208 56 HUPDAT 5 0 fb1d0 1000dd 415 0 98 98 1
    fb240 56 HUPDAT 5 0 fb208 1000dd 416 0 96 96 1
    fb278 56 HUPDAT 5 0 fb240 1000dd 417 0 97 97 1
    fb2b0 56 HUPDAT 5 0 fb278 1000dd 418 0 99 99 1
    fb2e8 36 COMMIT 5 0 fb2b0 11/15/2005 15:20:30
    fc018 40 BEGIN 5 4 0 11/15/2005 15:20:30 18 unknown
    fc040 48 HINSERT 5 0 fc018 1000a3 101 4
    fc070 36 COMMIT 5 0 fc040 11/15/2005 15:20:30
    fd018 40 BEGIN 5 4 0 11/15/2005 15:20:32 20 informix
    fd040 48 HDELETE 5 0 fd018 1000a3 101 4

    addr len type xid id link
    fd070 36 COMMIT 5 0 fd040 11/15/2005 15:20:32
    fe018 40 BEGIN 7 4 0 11/15/2005 15:20:44 19 unknown
    fe040 192 ADDDBS 7 0 fe018 ift_1 informix
    fe100 424 ADDCHK 7 0 fe040 2 D:\IFMXDATA\ift_1\ift_1_dat.000
    fe2a8 2604 DPT 1 4 0 321
    fecd4 56 CKPOINT 1 0 fe2a8 1
    begin xid id addr user
    4 7 4 fe100 unknown
    ff018 36 COMMIT 7 0 fe100 11/15/2005 15:20:46
    100018 40 BEGIN 7 4 0 11/15/2005 15:20:52 21 unknown
    100040 192 ADDDBS 7 0 100018 sbspace informix
    100100 424 ADDCHK 7 0 100040 3 D:\IFMXDATA\ift_1\sbspace_dat.000
    1002a8 2604 DPT 1 4 0 321
    100cd4 56 CKPOINT 1 0 1002a8 1
    begin xid id addr user
    4 7 4 100100 unknown
    101018 36 CHALLOC 7 0 100100 300035 1737
    10103c 36 CHALLOC 7 0 101018 30176c 35d

    addr len type xid id link
    101060 36 CHALLOC 7 0 10103c 301ac9 1737
    101084 36 CHFREE 7 0 101060 30176c 35d
    1010a8 372 BLDCL 7 0 101084 300002 4 4 4064 0 sbspace_desc
    10121c 36 CHALLOC 7 0 1010a8 30176c 4
    101240 40 PTEXTEND 7 0 10121c 300002 3 30176c
    101268 372 BLDCL 7 0 101240 300003 4 4 56 0 chunk_adjunc
    1013dc 36 CHALLOC 7 0 101268 301770 4
    101400 40 PTEXTEND 7 0 1013dc 300003 3 301770
    101428 940 HINSERT 7 0 101400 300002 101 896
    1017d4 372 BLDCL 7 0 101428 300004 287 350 456 0 LO_hdr_partn
    101948 36 CHALLOC 7 0 1017d4 301774 11f
    10196c 40 PTEXTEND 7 0 101948 300004 286 301774
    101994 372 BLDCL 7 0 10196c 300005 10 5 4064 0 LO_ud_free
    101b08 36 CHALLOC 7 0 101994 301893 a
    101b2c 40 PTEXTEND 7 0 101b08 300005 9 301893
    101b54 44 ALLOCGP 7 0 101b2c 300003 1
    101b80 100 HINSERT 7 0 101b54 300003 101 56
    101be4 4108 HINSERT 7 0 101b80 300005 101 4064

    addr len type xid id link
    102c0c 32 SBLOB 7 0 101be4 ADDSBCHK 3
    102c2c 40 SBLOB 7 0 102c0c CHFREE (3,53,5943)
    102c54 40 SBLOB 7 0 102c2c CHFREE (3,6857,5943)
    102c7c 36 COMMIT 7 0 102c54 11/15/2005 15:20:53
    103018 32 CKPOINT 1 4 0 0
    104018 32 CKPOINT 1 4 0 0
    105018 32 CKPOINT 1 4 0 0
    106018 32 CKPOINT 1 4 0 0
    Last edited by madey; 11-15-05 at 22:27. Reason: Careless

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Madey,

    Estas en la facultad de Filosofía ???

Posting Permissions

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