Commands to enable and disable DATABASE LOGGING
Navaid Arif
Martin Fuerderer
as user informix:
ontape -s -L 0 -U <database> # switch to unbuffered logging
ontape -s -L 0 -N <database> # switch to no logging
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
Sorry, but the following text is now required by German law:
IBM Deutschland GmbH
Vorsitzender des Aufsichtsrats: Hans Ulrich Maerki
Geschäftsführung: Martin Jetter (Vorsitzender), Rudolf
Bauer, Christian Diedrich, Christoph Grandpierre,
Matthias Hartmann, Andreas Kerstan
Sitz der Gesellschaft: Stuttgart
Registergericht: Amtsgericht Stuttgart, HRB 14562
WEEE-Reg.-Nr. DE 99369940
> Navaid Arif_______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Dattatreya Govindappanavar
As informix run:
ondblog nolog <list of databases>
ondblog unbuf <list of databases> <<level 0 archive of all the spaces where this database object are present is needed before you use this database
For more information refer to:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.adref.doc/adref295.htm
http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.admin.doc/admin461.htm
http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.admin.doc/admin463.htm
| "Navaid Arif"
<navai...@access.net.pk>
Sent by: informix-l...@iiug.org 03/14/2007 02:25 AM |
|
Dattatreya Govindappanavar
Clarification:
You would need Level-0 archive of affected spaces only if you are changing the logging mode from nolog to any other logging type.
| Dattatreya Govindappanavar/Lenexa/IBM@IBMUS
Sent by: informix-l...@iiug.org 03/14/2007 09:27 AM |
|
Navaid Arif
CREATE PROCEDURE pdc_card_lmt_upd
(
lcard_no varchar(19),
lnew_fdy_lmt float,
lnew_fwk_lmt float,
lnew_mth_lmt float,
lstatus char(3),
laction char(20),
luser_id char(15)
)CREATE PROCEDURE pdc_card_lmt_upd
(
lacc_no varchar(19),
lnew_crd_lmt float,
lacc_status char(1),
laction char(20),
luser_id char(15)
)
drop procedure pdc_card_lmt_upd;
9700: Routine (pdc_card_lmt_upd) ambiguous - more than one routine resolves to given signature.
Eric Rowell
ei:
DROP PROCEDURE pdc_card_lmt_upd (varchar(19), float, float, float,
char(1),
char(20), char(15));
or
DROP PROCEDURE pdc_card_lmt_upd (varchar(19), float, char(1), char(20),
char(15));
When there is only one then a normal drop does drop properly.
Eric B. Rowell
Navaid Arif
###########
#/etc/hosts
###########
127.0.0.1 loopback localhost # loopback (lo0) name/address172.16.1.72 srvtest
172.16.5.90 eftdr##################
#/etc/hosts.equiv
##################
172.16.5.90 informix+ eft
+ informix
+ tts###############
#/etc/services
###############
testport 5126/tcp
svceft 5123/tcp##############################
#/informix/ids10/etc/sqlhosts
##############################
#=========
#PRIMARY
#=========
grppri group - - i=2
srvtest onsoctcp srvtest testport g=grppri#========
#TARGET
#========grpdr group - - i=1
eftdr onsoctcp eftdr svceft g=grpdr
(
name1 varchar(20),
name2 varchar(20),
primary key (name1) constraint ids_name3
);
create table merchtbl
(
est_id char(15),
mer_name char(50),
org_type char(3),
active char(1),
txn_curr char(3),
flr_lmt float,
com_rate integer,
txn_decpt smallint,
term_type char(1),
category char(4),
m_mcc char(4),
tcc char(1),
addr1 char(100),
addr2 char(100),
area_cd varchar(3),
settle_city varchar(30),
zipcode char(10),
num_country char(3),
site_code char(3),
time_zone char(3),
stand_in char(1),
alpha_country char(3),
mne_country char(2),
defer_flag char(1),
rps_flag char(1),
ec_indicator char(1),
self_srv_term char(1),
fleet_flag char(1),
cont_name char(32),
cont_phone1 char(32),
cont_phone2 char(32),
dba_mer_name varchar(50),
dba_addr1 varchar(100),
dba_addr2 varchar(100),
dba_area_cd varchar(3),
dba_set_city varchar(30),
dba_location varchar(30),
region_cd char(3),
cr_comm_type char(1),
cr_comm_type2 char(1),
cr_comm_rate float,
db_comm_type char(1),
db_comm_type2 char(1),
db_comm_rate float,
fc_comm_type char(1),
fc_comm_type2 char(1),
fc_comm_rate float,
tts_exp_bin_id char(8),
fc_serv_st_id char(8),
ut_flag char(1),
ut_nwk_id char(8),
utp_nwk_id char(8),
utp_access_no char(12),
utp_cust_no char(12),
utp_void_flag char(1),
ut_void_flag char(1),
rec_type char(1),
user_id char(10),
last_mdate char(8),
last_mtime char(6),
primary key (est_id) constraint merchtbl_estid_pk
);
srvtest
EFT-Test >onstat -
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
grpdr 1 Active Connected 0 Apr 14 20:03:44
grppri 2 Active Local 0
EFT-Test >cdr list repl
-------------------------------
REPLICATE: rp72_dralways
STATE: Active ON:grppri
CONFLICT: Always Apply
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: orixeft:eft.dralways
OPTIONS: transaction,ris,ats,fullrow
REPLID: 131073 / 0x20001
REPLMODE: PRIMARY ON:grppri
APPLY-AS: INFORMIX ON:grppri
STATE: Active ON:grppri
CONFLICT: Always Apply
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: orixeft:eft.merchtbl
OPTIONS: transaction,ris,ats,fullrow
REPLID: 131077 / 0x20005
REPLMODE: PRIMARY ON:grppri
APPLY-AS: INFORMIX ON:grppri
----------------------------------------------------------------------------
rp72_dralways orixeft@grpdr:eft.dralways select * from dralways
rp72_dralways orixeft@grppri:eft.dralways select * from dralways
rp72_merchtbl orixeft@grpdr:eft.merchtbl select * from merchtbl
rp72_merchtbl orixeft@grppri:eft.merchtbl select * from merchtbl
EFT-Test >
###########
/etc/hosts
###########
127.0.0.1 loopback localhost # loopback (lo0) name/address172.16.5.90 eftdr
172.16.1.72 srvtest##################
/etc/hosts.equiv
##################
172.16.1.72 informix+ eft
+ informix
+ tts###############
/etc/services
###############
svceft 5123/tcp # DR server INFORMIX port
testport 5126/tcp # Pri Server INFORMIX port##############################
/informix/ids10/etc/sqlhosts
##############################
#=======
DR-SITE
#=======
grpdr group - - i=1
eftdr onsoctcp eftdr svceft g=grpdr#========
ORIX-HO
#========
grppri group - - i=2
srvtest onsoctcp srvtest testport g=grppri##############################create table "eft".dralways
(
name1 varchar(20),
name2 varchar(20),
primary key (name1) constraint ids_name3
);create table merchtbl
(
est_id char(15),
mer_name varchar(50),
org_type char(3),
active char(1),
txn_curr char(3),
flr_lmt float,
com_rate integer,
txn_decpt smallint,
term_type char(1),
category char(4),
m_mcc char(4),
tcc char(1),
addr1 varchar(100),
addr2 varchar(100),
area_cd varchar(3),
settle_city varchar(30),
zipcode char(10),
num_country char(3),
site_code char(3),
time_zone char(3),
stand_in char(1),
alpha_country char(3),
mne_country char(2),
defer_flag char(1),
rps_flag char(1),
ec_indicator char(1),
self_srv_term char(1),
fleet_flag char(1),
cont_name char(32),
cont_phone1 char(32),
cont_phone2 char(32),
dba_mer_name varchar(50),
dba_addr1 varchar(100),
dba_addr2 varchar(100),
dba_area_cd varchar(3),
dba_set_city varchar(30),
dba_location varchar(30),
region_cd char(3),
cr_comm_type char(1),
cr_comm_type2 char(1),
cr_comm_rate float,
db_comm_type char(1),
db_comm_type2 char(1),
db_comm_rate float,
fc_comm_type char(1),
fc_comm_type2 char(1),
fc_comm_rate float,
tts_exp_bin_id char(8),
fc_serv_st_id char(8),
ut_flag char(1),
ut_nwk_id char(8),
utp_nwk_id char(8),
utp_access_no char(12),
utp_cust_no char(12),
utp_void_flag char(1),
ut_void_flag char(1),
rec_type char(1),
user_id char(10),
last_mdate char(8),
last_mtime char(6),
primary key (est_id) constraint "informix".merchtbl_estid_pk
);EFT-DR-90 >hostname
eftdr
EFT-DR-90 >onstat -IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 01:51:10 -- 41664 KbytesEFT-DR-90 >cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
grpdr 1 Active Local 0
grppri 2 Active Connected 0 Apr 14 19:59:09
EFT-DR-90 >cdr list replCURRENTLY DEFINED REPLICATES
-------------------------------
REPLICATE: rp72_dralways
STATE: Active ON:grpdr
CONFLICT: Always Apply
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: orixeft:eft.dralways
OPTIONS: transaction,ris,ats,fullrow
REPLID: 131073 / 0x20001
REPLMODE: READ-ONLY ON:grpdr
APPLY-AS: INFORMIX ON:grpdrREPLICATE: rp72_merchtbl
STATE: Active ON:grpdr
CONFLICT: Always Apply
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: orixeft:eft.merchtbl
OPTIONS: transaction,ris,ats,fullrow
REPLID: 131077 / 0x20005
REPLMODE: READ-ONLY ON:grpdr
APPLY-AS: INFORMIX ON:grpdrEFT-DR-90 >cdr list repl briefREPLICATE TABLE SELECT
----------------------------------------------------------------------------
rp72_dralways orixeft@grpdr:eft.dralways select * from dralways
rp72_dralways orixeft@grppri:eft.dralways select * from dralways
rp72_merchtbl orixeft@grpdr:eft.merchtbl select * from merchtbl
rp72_merchtbl orixeft@grppri:eft.merchtbl select * from merchtbl
EFT-DR-90 >
Navaid Arif
Regards,
Navaid Arif
Andreas Legner
I'd say there's nothing obviously wrong in your outputs and the setup seems to be proper.
Are you still seeing the problem? Did I get you right that the rp72_merchtbl (131077) replicate isn't replicating while
rp72_dralways (131073) is?
Do you see any errors in your both online.log files around the time where you defined the 'bad' replicate?
Can you post a 'select * from syscdr:partdef where repid = 133077', please?
Regards,
Andreas
Navaid Arif
SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Modify the current SQL statements using the SQL editor.----------------------- dbname@srvtest -------- Press CTRL-W for Help --------load from loghisttbl.dmp insert into loghisttbl
458: Long transaction aborted. 12204: RSAM error: Long transaction detected.
847: Error in load file line 5825.
Keith Simmons
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
This is not directly related to ER, you have simply started a
transaction that has exceeded the LTX limits in you onconfig file.
Either add more logs space, split the file into smaller lumps and load
each as a separate transaction, craete the table as RAW, load the data
and then change the table to standard or turn logging off on the
database, load the data then turn loging back on.
Keith
Navaid Arif
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
Superboer
have a look at
onparams -a ( -d......)
Superboer.
Navaid Arif
Test >onstat -lIBM Informix Dynamic Server Version 10.00.UC5 -- Quiescent -- Up 00:55:25 -- 46240 KbytesPhysical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 6 8 8337 1196 6.97
phybegin physize phypos phyused %used
8:6931 5000 4627 6 0.12Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 8 1326284 29680 4626 44.7 6.4
Subsystem numrecs Log Space used
OLDRSAM 1326282 116667676
SBLOB 1 44
CDR 1 40address number flags uniqid begin size used %used
502344b0 1 U-B---- 534 1:763 500 500 100.00
502344f8 2 U-B---- 535 1:1263 500 500 100.00
50234540 3 U-B---- 536 1:1763 500 500 100.00
50234588 4 U-B---- 537 1:2263 500 500 100.00
502345d0 7 U-B---- 538 8:923 500 500 100.00
50234618 5 U-B---- 539 1:2763 500 500 100.00
50234660 6 U-B---- 540 1:3263 500 500 100.00
502346a8 8 U-B---- 541 4:71993 500 500 100.00
502346f0 11 U-B---- 542 4:72993 500 500 100.00
50234738 9 U-B---- 543 4:72493 500 500 100.00
50234780 10 U-B---- 544 8:1431 500 500 100.00
502347c8 12 U-B---- 545 8:1931 5000 5000 100.00
50234810 13 U-B---- 546 8:11931 5000 5000 100.00
50234858 14 U-B---- 547 8:16931 5000 5000 100.00
502348a0 15 U---C-L 548 8:21931 5000 317 6.34
502348e8 16 U-B---- 530 8:26931 5000 5000 100.00
50234930 17 U-B---- 531 6:3 5000 5000 100.00
50234978 18 U-B---- 532 6:5003 5000 5000 100.00
502349c0 19 U-B---- 533 6:10003 5000 5000 100.00
604bbfb0 20 A------ 0 6:15003 5000 0 0.00
20 active, 20 totalTest >
----- Original Message -----From: Navaid ArifSent: Wednesday, May 02, 2007 11:36 AMSubject: Error in Enterprise ReplicationHi All,I am using IDS 10 UC5 and during testing of Enterprise Replication facing following problem: Anyone have any idea about it?SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Modify the current SQL statements using the SQL editor.----------------------- dbname@srvtest -------- Press CTRL-W for Help --------load from loghisttbl.dmp insert into loghisttbl
458: Long transaction aborted. 12204: RSAM error: Long transaction detected.
847: Error in load file line 5825.Regards,Navaid Arif
Link, David A. (Omaha)
Navaid,
You need to load the data in smaller chunks. You are opening a transaction at the beginning of the insert and then you start inserting records, these inserts are getting put into the logical logs. You cannot wrap around the opening of the transaction, “BEGIN WORK”.
I would suggest you use dbload to load the data using smaller transaction sets.
David
John Carlson
Logical log usage doesn't seem to be a problem. The problem is that
you are apparently trying to load too much data in a single
transaction. Like David said, you can use dbload to set a commit
point after every 'x' rows, which will make your life much easier.
The problem with adding logs only to take care of a long transaction
is that the exact number / size of logs to add isn't known. It's
usually much easier to either use dbload or UNIX 'split' (assuming
this is a UNIX box) to break up the data into smaller chunks to load.
JWC
Navaid Arif
Test >onstat -lIBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 00:00:27 -- 46240 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 8 7 1 7.00
phybegin physize phypos phyused %used
8:6931 2500 15 8 0.32
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 8 31 5 5 6.2 1.0
Subsystem numrecs Log Space used
OLDRSAM 31 1952
address number flags uniqid begin size used %used
502344b0 1 U-B---- 534 1:763 500 500 100.00
502344f8 2 U-B---- 535 1:1263 500 500 100.00
50234540 3 U-B---- 536 1:1763 500 500 100.00
50234588 4 U-B---- 537 1:2263 500 500 100.00
502345d0 7 U-B---- 538 8:923 500 500 100.00
50234618 5 U-B---- 539 1:2763 500 500 100.00
50234660 6 U-B---- 540 1:3263 500 500 100.00
502346a8 8 U-B---- 541 4:71993 500 500 100.00
502346f0 11 U-B---- 542 4:72993 500 500 100.00
50234738 9 U-B---- 543 4:72493 500 500 100.00
50234780 10 U-B---- 544 8:1431 500 500 100.00
502347c8 12 U-B---- 545 8:1931 5000 5000 100.00
50234810 13 U-B---- 546 8:11931 5000 5000 100.00
50234858 14 U-B---- 547 8:16931 5000 5000 100.00
502348a0 15 U---C-L 548 8:21931 5000 2117 42.34
502348e8 16 U-B---- 530 8:26931 5000 5000 100.00
50234930 17 U-B---- 531 6:3 5000 5000 100.00
50234978 18 U-B---- 532 6:5003 5000 5000 100.00
502349c0 19 U-B---- 533 6:10003 5000 5000 100.00
19 active, 19 totalTest >onparams -d -l 19 -y
Enterprise Replication is not yet done snooping this log.
Drop failed.
ISAM error: Unexpected internal error
Test >oninit
oninit: Fatal error in shared memory creation
Test >onstat -IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 00:04:05 -- 46240 KbytesTest >cdr stop
command failed -- Enterprise Replication not active (62)
Test >
----- Original Message -----From: Navaid ArifSent: Wednesday, May 16, 2007 6:12 PMSubject: Re: Error in Enterprise Replication
Test >
Navaid Arif
Test >cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
grpdr 1 Active Connected 11029146 May 22 11:10:13
grppri 2 Active Local 0
Test >cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
grpdr 1 Active Connected 10929786 May 22 11:10:13
grppri 2 Active Local 0
Navaid Arif
Test >onstat -lIBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 5 128 1303 104 12.53
phybegin physize phypos phyused %used
1:263 2500 497 5 0.20
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 128 90892 18432 2667 4.9 6.9
Subsystem numrecs Log Space used
OLDRSAM 81180 43897416
SBLOB 9706 22230368
CDR 6 296
address number flags uniqid begin size used %used
502ac4b0 1 U-B---- 67 1:2763 5000 5000 100.00
502ac4f8 2 U-B---- 68 1:7763 5000 5000 100.00
502ac540 3 U-B---- 69 1:12763 5000 5000 100.00
502ac588 4 U-B---- 70 1:17763 5000 5000 100.00
502ac5d0 5 U-B---- 71 1:22763 5000 5000 100.00
502ac618 6 U-B---- 72 1:27763 5000 5000 100.00
502ac660 7 U-B---- 73 1:32763 5000 5000 100.00
502ac6a8 8 U---C-L 74 1:37763 5000 355 7.10
502ac6f0 9 U-B---- 42 1:42763 5000 5000 100.00
502ac738 10 U-B---- 43 1:47763 5000 5000 100.00
502ac780 11 U-B---- 44 1:52763 5000 5000 100.00
502ac7c8 12 U-B---- 45 1:57763 5000 5000 100.00
502ac810 13 U-B---- 46 1:62763 5000 5000 100.00
502ac858 14 U-B---- 47 1:67763 5000 5000 100.00
502ac8a0 15 U-B---- 48 1:72763 5000 5000 100.00
502ac8e8 16 U-B---- 49 1:77763 5000 5000 100.00
502ac930 17 U-B---- 50 1:82763 5000 5000 100.00
502ac978 18 U-B---- 51 1:87763 5000 5000 100.00
502ac9c0 19 U-B---- 52 1:92763 5000 5000 100.00
502aca08 20 U-B---- 53 1:97763 5000 5000 100.00
502aca50 21 U-B---- 54 1:102763 5000 5000 100.00
502aca98 22 U-B---- 55 1:107763 5000 5000 100.00
502acae0 23 U-B---- 56 1:112763 5000 5000 100.00
502acb28 24 U-B---- 57 1:117763 5000 5000 100.00
502acb70 25 U-B---- 58 1:122763 5000 5000 100.00
502acbb8 26 U-B---- 59 1:127763 5000 5000 100.00
502acc00 27 U-B---- 60 1:132763 5000 5000 100.00
502acc48 28 U-B---- 61 1:137763 5000 5000 100.00
502acc90 29 U-B---- 62 1:142763 5000 5000 100.00
502accd8 30 U-B---- 63 1:147763 5000 5000 100.00
502acd20 31 U-B---- 64 1:155688 5000 5000 100.00
502acd68 32 U-B---- 65 1:160688 5000 5000 100.00
502acdb0 33 U-B---- 66 1:165688 5000 5000 100.00
33 active, 33 totalTest >
18:54:33 Maximum server connections 13
18:59:33 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
18:59:33 Checkpoint loguniq 71, logpos 0x83e060, timestamp: 0x16d4e7f18:59:33 Maximum server connections 13
19:04:34 Fuzzy Checkpoint Completed: duration was 0 seconds, 8 buffers not flushed.
19:04:34 Checkpoint loguniq 71, logpos 0x854960, timestamp: 0x16d52db19:04:34 Maximum server connections 13
19:09:34 Fuzzy Checkpoint Completed: duration was 0 seconds, 16 buffers not flushed.
19:09:34 Checkpoint loguniq 71, logpos 0x86f140, timestamp: 0x16d56af19:09:34 Maximum server connections 13
19:11:04 dynamically allocated 2000 locks
19:11:07 WARNING: Buffer pool size is too small for read ahead operation19:11:15 dynamically allocated 4000 locks
19:11:21 Logical Log 71 Complete, timestamp: 0x16dbb35.
19:11:47 Warning - The log space appears to be configured too small
for use with Enterprise Replication (ER). ER may require
additional logical logs to avoid a DDRBLOCK state
and/or replay position log wrap. It is recommended that the
logical log configuration be expanded.
19:12:14 dynamically allocated 8000 locks
19:12:19 Logical Log 72 Complete, timestamp: 0x16e73e7.
19:12:34 CDR NIF receive failed asfcode: -25582 oserr 0
19:12:35 CDR connection to server lost, id 1, name <grpdr>
Reason: connection lost
19:13:52 Dynamically allocated new virtual shared memory segment (size 8192KB)
19:14:46 Fuzzy Checkpoint Completed: duration was 3 seconds, 1132 buffers not flushed.
19:14:46 Checkpoint loguniq 73, logpos 0x1371770, timestamp: 0x16ee46b19:14:46 Maximum server connections 13
19:17:58 CDR: Re-connected to server, id 1, name <grpdr>
19:19:46 Fuzzy Checkpoint Completed: duration was 0 seconds, 1135 buffers not flushed.
19:19:46 Checkpoint loguniq 73, logpos 0x13817a0, timestamp: 0x16ee7b219:19:46 Maximum server connections 13
19:20:48 Logical Log 73 Complete, timestamp: 0x16ee9b7.
19:24:46 Fuzzy Checkpoint Completed: duration was 0 seconds, 1140 buffers not flushed.
19:24:46 Checkpoint loguniq 74, logpos 0xfb7f0, timestamp: 0x16ef16d19:24:46 Maximum server connections 13
19:29:49 Fuzzy Checkpoint Completed: duration was 3 seconds, 9 buffers not flushed.
19:29:49 Checkpoint loguniq 74, logpos 0x1040d0, timestamp: 0x16ef47819:29:49 Maximum server connections 13
19:33:29 Dynamically allocated new virtual shared memory segment (size 8192KB)
19:34:49 Fuzzy Checkpoint Completed: duration was 0 seconds, 6 buffers not flushed.
19:34:49 Checkpoint loguniq 74, logpos 0x10f3a0, timestamp: 0x16ef781
Madison Pruet
We internally are calculating the rate of advancing the replay position
with the rate of advancing the current log position. Based on the
current rates of change of the current and replay position it appears
that we could run into a log wrap within an hour, then we print the
warning. You might see this in the case where you where you ran a
heavy load, or maybe a larger than usual updating transaction.
>
>
> Regards,
> *Navaid Arif*
da...@smooth1.co.uk
>
> - Show quoted text -
Do you know what LTXHWM and LTXEHWM do? 120 is not a valid value.
You should never set LTXHWM above 30 and LTXEHWM above 40.
YOu need to add more log space say 100 logs of 50Mb each for 5GB more
log space.
da...@smooth1.co.uk
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>
> - Show quoted text -
" 9 more logical logs of 20MB each", you are taking the piss right?
These says we have disk drives to 1Tb and you are wondering why 180Mb
of not enough.
Add at least 100 logs of 50Mb each and then drop the existing logs.
Make sur ethe physical log is at least 1Gb.
Then try again.
Navaid Arif
12:39:35 Maximum server connections 123
12:42:09 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG
12:42:09 create_tcb: cannot allocate memory
12:42:09 (5099) connection rejected - too many users, or invalid user name
12:42:09 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create a user thread.
12:42:12 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG
12:42:12 create_tcb: cannot allocate memory
12:42:12 (5100) connection rejected - too many users, or invalid user name
12:42:12 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create a user thread.
12:42:18 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG
12:42:18 create_tcb: cannot allocate memory
.
.
.
12:42:44 (5106) connection rejected - too many users, or invalid user name
12:42:44 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create a user thread.
12:42:45 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG
12:42:46 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG
12:42:46 create_tcb: cannot allocate memory
12:42:46 (5107) connection rejected - too many users, or invalid user name
12:42:46 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create a user thread.
.
.
.
13:17:14 1024 incomplete connections at this time. System might be under attack through
invalid clients on the listener port.
13:17:24 1024 incomplete connections at this time. System might be under attack through
invalid clients on the listener port.
13:17:32 1024 incomplete connections at this time. System might be under attack through
invalid clients on the listener port.
13:17:35 1024 incomplete connections at this time. System might be under attack through
invalid clients on the listener port.
13:17:50 Shutdown Mode
13:17:52 Checkpoint Completed: duration was 0 seconds.
13:17:52 Checkpoint loguniq 1114, logpos 0x156018, timestamp: 0x8d17cb3513:17:52 Maximum server connections 123
13:17:53 IBM Informix Dynamic Server Stopped.13:18:00 IBM Informix Dynamic Server Started.
Everett Mills
Your server ran out of shared memory resources. Check your shared memory kernel parameters. You probably need to increase some of them.
--EEM
________________________________________
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of Navaid Arif
Sent: Friday, July 06, 2007 10:29 AM
Subject: IDS Response Problem
Importance: High
Fernando Nunes
Apparently it ran out of memory.
Since you're using UC5 check this:
Did you change your system recently?
If this isn't the case, try to figure out where the memory is going... onstat
can help.
Regards.
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
Neil Truby
memory segments? Could it be worth your while checking the value of SHMSEG?
Suggested settings on UNIX/Linux kernel parameners can be found in a
sub-directory of $INFORMIXDIR/release
--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil....@ardenta.com
"Navaid Arif" <navai...@access.net.pk> wrote in message
news:mailman.379.118373559...@iiug.org...
Navaid Arif
13:42:54 CDR grouper memory allocation failed (Evaluator replication ID).
13:42:54 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG13:42:54 out of virtual shared memory13:42:54 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG13:42:54 out of virtual shared memory13:42:54 CDR grouper memory allocation failed (FanOut update link).
13:42:54 CDR Grouper FanOut thread is aborting.
13:42:54 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG13:42:54 out of virtual shared memory
Sun Aug 5 01:15:02 200701:15:02 Event alarms enabled. ALARMPROG = '/informix/ids10/etc/alarmprogram.sh'
01:15:02 Booting Language <c> from module <>
01:15:02 Loading Module <CNULL>
01:15:02 Booting Language <builtin> from module <>
01:15:02 Loading Module <BUILTINNULL>
01:15:06 Dynamically allocated new virtual shared memory segment (size 8192KB)
01:15:07 DR: DRAUTO is 0 (Off)
01:15:07 AIX MP latch code enabled
01:15:08 IBM Informix Dynamic Server Version 10.00.UC5 Software Serial Number AAA#B000000
01:15:08 KAIO: error in kaio_READ, kaiocbp = 0x5024c7c8, errno = 14
01:15:08 fildes = 256 (gfd 4), buf = 0x60048c00, nbytes = 4096, offset = 0
01:15:08 Assert Warning: chunk failed sanity check01:15:08 IBM Informix Dynamic Server Version 10.00.UC5
01:15:08 Who: Session(1, informix@appsec, 0, 50226018)
Thread(7, main_loop(), 501fd018, 1)
File: rspartn.c Line: 8673
01:15:08 Results: Chunk 2 is being taken OFFLINE.
01:15:08 Action: Restore chunk from archive.
01:15:08 stack trace for pid 20888 written to /informix/ids10/tmp/af.3efde4c
01:15:08 See Also: /informix/ids10/tmp/af.3efde4c
01:15:09 chunk failed sanity check01:15:10 I/O error, Primary Chunk '/app/db/app_lnk_dbs' -- Offline (sanity)
01:15:11 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.01:15:11 Physical Recovery Started at Page (1:31950).
01:15:11 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
01:15:11 Assert Warning: pthdrpage:ptalloc:bad bfget
01:15:11 IBM Informix Dynamic Server Version 10.00.UC5
01:15:11 Who: Session(7, informix@appsec, 0, 50226838)
Thread(22, fast_rec, 501fe448, 1)
File: rspartn.c Line: 6726
01:15:11 Results: Cannot use TBLSpace page for TBLSpace 2097153
01:15:11 Action: Run 'oncheck -pt 2097153'
01:15:11 stack trace for pid 20888 written to /informix/ids10/tmp/af.3fede4f
01:15:11 See Also: /informix/ids10/tmp/af.3fede4f
01:15:13 pthdrpage:ptalloc:bad bfget
01:15:13 Assert Failed: Chunk 2 is being taken OFFLINE.
01:15:13 IBM Informix Dynamic Server Version 10.00.UC5
01:15:13 Who: Session(7, informix@appsec, 0, 50226838)
Thread(22, fast_rec, 501fe448, 1)
File: rspartn.c Line: 6744
01:15:13 Results: Cannot Open DBspace 2.
01:15:13 Action: Restore chunk from archive.
01:15:13 stack trace for pid 20888 written to /informix/ids10/tmp/af.3fede4f
01:15:13 See Also: /informix/ids10/tmp/af.3fede4f
01:15:17 Chunk 2 is being taken OFFLINE.
01:15:17 Assert Warning: Chunk 2 is being taken OFFLINE.
01:15:17 IBM Informix Dynamic Server Version 10.00.UC5
01:15:17 Who: Session(7, informix@appsec, 0, 50226838)
Madison Pruet
> Hi All,
> I am using IDS 10:00 UC5 on AIX 5.3 and replicating my data on my
> DR-Site using Enterprise Replication. I am also running an important
> application on this machine which uses IDS databases. Replication works
> perfectly fine until I run a daily cutoff process. Whenever this process
> executes following messages appears in ONLINE.LOG
Need to see the onconfig file, and also onstat -g seg at the time of the
problem.
> <mailto:informix@appsec>, 0, 50226018)
> Thread(7, main_loop(), 501fd018, 1)
> File: rspartn.c Line: 8673
> 01:15:08 Results: Chunk 2 is being taken OFFLINE.
> 01:15:08 Action: Restore chunk from archive.
> 01:15:08 stack trace for pid 20888 written to
> /informix/ids10/tmp/af.3efde4c
> 01:15:08 See Also: /informix/ids10/tmp/af.3efde4c
> 01:15:09 chunk failed sanity check
>
> 01:15:10 I/O error, Primary Chunk '/app/db/app_lnk_dbs' --
> Offline (sanity)
> 01:15:11 IBM Informix Dynamic Server Initialized -- Shared
> Memory Initialized.
>
> 01:15:11 Physical Recovery Started at Page (1:31950).
> 01:15:11 Physical Recovery Complete: 0 Pages Examined, 0 Pages
> Restored.
> 01:15:11 Assert Warning: pthdrpage:ptalloc:bad bfget
> 01:15:11 IBM Informix Dynamic Server Version 10.00.UC5
> 01:15:11 Who: Session(7, informix@appsec
> <mailto:informix@appsec>, 0, 50226838)
> Thread(22, fast_rec, 501fe448, 1)
> File: rspartn.c Line: 6726
> 01:15:11 Results: Cannot use TBLSpace page for TBLSpace 2097153
> 01:15:11 Action: Run 'oncheck -pt 2097153'
> 01:15:11 stack trace for pid 20888 written to
> /informix/ids10/tmp/af.3fede4f
> 01:15:11 See Also: /informix/ids10/tmp/af.3fede4f
> 01:15:13 pthdrpage:ptalloc:bad bfget
> 01:15:13 Assert Failed: Chunk 2 is being taken OFFLINE.
> 01:15:13 IBM Informix Dynamic Server Version 10.00.UC5
> 01:15:13 Who: Session(7, informix@appsec
> <mailto:informix@appsec>, 0, 50226838)
> Thread(22, fast_rec, 501fe448, 1)
> File: rspartn.c Line: 6744
> 01:15:13 Results: Cannot Open DBspace 2.
> 01:15:13 Action: Restore chunk from archive.
> 01:15:13 stack trace for pid 20888 written to
> /informix/ids10/tmp/af.3fede4f
> 01:15:13 See Also: /informix/ids10/tmp/af.3fede4f
> 01:15:17 Chunk 2 is being taken OFFLINE.
> 01:15:17 Assert Warning: Chunk 2 is being taken OFFLINE.
> 01:15:17 IBM Informix Dynamic Server Version 10.00.UC5
> 01:15:17 Who: Session(7, informix@appsec
> <mailto:informix@appsec>, 0, 50226838)
>
> I will really appreciate, if someone can help me in this regard.
>
>
> Regards,
> *Navaid Arif*