RSS not working

Hello I have an interresting problem I have 2 servers when they I do a level 0 backup on primary. setup the RSS on Primary Send the backup to my secondary run ontape -p. connect the secondary to primary the primary sends this error 12:29:07 RSS Server drcastxliveca - state is now connected 12:29:08 Can not send log 82043 my logs start at -rw-rw---- 1 informix informix 10420224 Oct 06 14:30 liveca_Log0000082044 I think what going on is that I'm creating a backup then flushing my logs

same problem on this server pair 13:29:33 RSS Server drukstxliveuk - state is now connected 13:29:33 Can not send log 198818 -bash-4.2$ ls -lap /llog/liveukllog/total 5006624 drwxrwxrwx 2 informix informix 12288 Oct 08 13:05 ./ drwxr-xr-x 5 informix informix 256 Oct 01 15:40 ../ -rw-rw---- 1 informix informix 10420224 Oct 06 14:39 liveuk_Log0000198818 -rw-rw---- 1 informix informix 10420224 Oct 06 14:45 liveuk_Log0000198819 -rw-rw---- 1 informix informix 10420224 Oct 06 14:45 liveuk_Log0000198820

What do you mean by "flushing my logs"? From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/08/2014 11:58 AM Subject: RSS not working [33928] Sent by: ids-bounces@iiug.org Hello I have an interresting problem I have 2 servers when they I do a level 0 backup on primary. setup the RSS on Primary Send the backup to my secondary run ontape -p. connect the secondary to primary the primary sends this error 12:29:07 RSS Server drcastxliveca - state is now connected 12:29:08 Can not send log 82043 my logs start at -rw-rw---- 1 informix informix 10420224 Oct 06 14:30 liveca_Log00000820= 44 I think what going on is that I'm creating a backup then flushing my lo= gs ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

I write my logs to a dir using ontape. after my backup completes I clean out that dir.

Are you using RSS flow control? Are you running a bunch of onmode -l commands as part of the backup? From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/08/2014 12:40 PM Subject: Re: RSS not working [33931] Sent by: ids-bounces@iiug.org I write my logs to a dir using ontape. after my backup completes I clea= n out that dir. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Oh yes - server version? ids-bounces@iiug.org wrote on 10/08/2014 12:39:46 PM: > From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> > To: ids@iiug.org > Date: 10/08/2014 12:40 PM > Subject: Re: RSS not working [33931] > Sent by: ids-bounces@iiug.org > > I write my logs to a dir using ontape. after my backup completes I clean out > that dir. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Im using default RSS flow control: DRAUTO 0 DRINTERVAL 0 DRTIMEOUT 60 HA_ALIAS livukstxliveuk DRLOSTFOUND /llog/liveuk_dr.lostfound DRIDXAUTO 1 LOG_INDEX_BUILDS 1 SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK TEMPTAB_NOLOG 1 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 Im not using onmode -l in my backup script : #!/bin/bash . $HOME/set.liveuk STARTM=`date -u "+%s"` rm /bkp/* ontape -d -s -L 0 > livukrpt && STOPM=`date -u "+%s"` RUNTIMEM=`expr $STOPM - $STARTM` if (($RUNTIMEM>59)); then TTIMEM=`printf "%dm%ds\\ " $((RUNTIMEM/60%60)) $((RUNTIMEM%60))` else TTIMEM=`printf "%ds\\ " $((RUNTIMEM))` fi echo "Daily Backup `date` for Data Base liveuk complete in $TTIMEM">>livukrpt rm /llog/liveukllog/* ontape -c & see after the ontape finishes I clean out the /llog/liveukllog then start my logging again

-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --

Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?

chunks on secondary are good bash-4.2$ onstat -d IBM Informix Dynamic Server Version 11.50.FC9 -- Fast Recovery (RSS) -- Up 22:32:53 -- 1200896 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 7000000307d7028 1 0x40401 1 2 4096 NP B informix rootdbs 7000000317ab028 2 0x40401 2 1 4096 NP B informix llogdbs 7000000317ab1c0 3 0x40401 3 1 4096 NP B informix plogdbs 7000000317ab358 4 0x40401 4 1 4096 NP B informix tempdbs 7000000317ab4f0 5 0x40401 5 3 4096 NP B informix objectdbs 7000000317ab688 6 0x40401 6 3 4096 NP B informix datadbs 7000000317ab820 7 0x48401 12 1 4096 NPSB informix sbs 7 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 7000000307d71c0 1 1 0 24000 2845 PI-B- /idsliveca/rdbsliveca 7000000317ab9b8 2 2 0 128000 447 PI-B- /idsliveca/llogdbsliveca 7000000317abba8 3 3 0 250000 24947 PI-B- /idsliveca/plogdbsliveca 7000000317abd98 4 4 0 12500 12172 PI-B- /idsliveca/tdbsliveca 7000000317ad028 5 5 0 250000 12 PI-B- /idsliveca/objdbsliveca 7000000317ad218 6 6 0 500000 2826 PI-B- /idsliveca/ddbsliveca01 7000000317ad408 7 5 0 1024000 24429 PI-B- /idsliveca/objdbsliveca02 7000000317ad5f8 8 6 0 1920000 2937 PI-B- /idsliveca/ddbsliveca02 7000000317ad7e8 9 5 0 2500000 1954241 PI-B- /idsliveca/objdbsliveca03 7000000317ad9d8 10 1 0 256000 231947 PI-B- /idsliveca/rdbsliveca2 7000000317adbc8 11 6 0 1310720 1310717 PI-B- /idsliveca/ddbsliveca03 7000000317addb8 12 7 0 25000 -1 -1 PISB- /idsliveca/sbs01 12 active, 32766 maximum NOTE: The values in the "size" and "free" columns for DBspace chunks are displayed in terms of "pgsize" of the DBspace to which they belong. Expanded chunk capacity mode: always

PRIMARY SERVER ONCONFIG -bash-4.2$ onstat -c IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 7 days 17:48:27 -- 1200896 Kbytes Configuration File: /apps/informix/etc/onconfig.liveca ROOTNAME rootdbs ROOTPATH /idsliveca/rdbsliveca ROOTOFFSET 0 ROOTSIZE 96000MIRROR 0 MIRRORPATH MIRROROFFSET 0 PHYSFILE 900000 PLOG_OVERFLOW_PATH /u/informix PHYSBUFF 256 LOGFILES 51 LOGSIZE 10000 DYNAMIC_LOGS 0 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH /llog/idslogs/idsliveca.log CONSOLE /llog/idslogs/idsliveca.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP tempdbs SBSPACETEMP SBSPACENAME SYSSBSPACENAME ONDBSPACEDOWN 2 SERVERNUM 20 DBSERVERNAME liveca DBSERVERALIASES livcastxliveca NETTYPE ipcshm,1,150,CPU NETTYPE soctcp,1,100,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 MULTIPROCESSOR 1 VPCLASS cpu,num=2,noage VP_MEMORY_CACHE_KB 0 SINGLE_CPU_VP 0 VPCLASS aio,num=3 CLEANERS 12AUTO_AIOVPS 1 DIRECT_IO 0 LOCKS 200000 DEF_TABLE_LOCKMODE page RESIDENT 0 SHMBASE 0x700000000000000L SHMVIRTSIZE 512000 SHMADD 256000 EXTSHMADD 8192 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300AUTO_CKPTS 1 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /bkp TAPEBLK 128 TAPESIZE 0 LTAPEDEV /llog/livecallog LTAPEBLK 64 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs DD_HASHSIZE 71 DD_HASHMAX 15 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 64 ALLOW_NEWLINE 0 USELASTCOMMITTED NONE FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000,alice=4 ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY 2048 DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 512 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 0AUTO_REPREPARE 1 RA_PAGES 64 RA_THRESHOLD 16 BATCHEDREAD_TABLE 0 EXPLAIN_STAT 1 #SQLTRACE level=low,ntraces=1000,size=2,mode=global #DBCREATE_PERMISSION informix #DB_LIBRARY_PATH IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 STAGEBLOB OPCACHEMAX 0 SQL_LOGICAL_CHAR OFF SEQ_CACHE_SIZE 10 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE sbs CDR_MAX_DYNAMIC_LOGS 0 CDR_SUPPRESS_ATSRISWARN DRAUTO 0 DRINTERVAL 2 DRTIMEOUT 60 HA_ALIAS livcastxliveca DRLOSTFOUND /llog/liveca_dr.lostfound DRIDXAUTO 1 LOG_INDEX_BUILDS 1 SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 DUMPDIR /llog/livecadump DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh RAS_PLOG_SPEED 0 RAS_LLOG_SPEED 2718 EILSEQ_COMPAT_MODE 0 QSTATS 0 WSTATS 0 LOW_MEMORY_RESERVE 0 LOW_MEMORY_MGR 0 GSKIT_VERSION #VPCLASS jvp,num=1 JVPJAVAHOME $INFORMIXDIR/extend/krakatoa/jre JVPHOME $INFORMIXDIR/extend/krakatoa JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops JVPLOGFILE $INFORMIXDIR/jvp.log #JDKVERSION 1.5 JVPJAVALIB /bin JVPJAVAVM jvm #JVPARGS -verbose:jni#JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g. jar JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 BUFFERPOOL size=4K,buffers=150000,lrus=31,lru_min_dirty=2.000000,lru_max_dirty=5.000000 BUFFERPOOL size=16K,buffers=1000,lrus=6,lru_min_dirty=0.500000,lru_max_dirty=2.000000 AUTO_LRU_TUNING 1

SECONDARY SERVER ONCONFIG -bash-4.2$ onstat -c IBM Informix Dynamic Server Version 11.50.FC9 -- Fast Recovery (RSS) -- Up 22:35:27 -- 1200896 Kbytes Configuration File: /apps/informix/etc/onconfig.drca ROOTNAME rootdbs ROOTPATH /idsliveca/rdbsliveca ROOTOFFSET 0 ROOTSIZE 96000MIRROR 0 MIRRORPATH MIRROROFFSET 0 PHYSFILE 900000 PLOG_OVERFLOW_PATH /u/informix PHYSBUFF 256 LOGFILES 51 LOGSIZE 10000 DYNAMIC_LOGS 0 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH /llog/idslogs/idsliveca.log CONSOLE /llog/idslogs/idsliveca.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP tempdbs SBSPACETEMP SBSPACENAME SYSSBSPACENAME ONDBSPACEDOWN 2 SERVERNUM 20 DBSERVERNAME liveca DBSERVERALIASES drcastxliveca NETTYPE ipcshm,1,150,CPU NETTYPE soctcp,1,100,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 MULTIPROCESSOR 1 VPCLASS cpu,num=2,noage VP_MEMORY_CACHE_KB 0 SINGLE_CPU_VP 0 VPCLASS aio,num=3 CLEANERS 12AUTO_AIOVPS 1 DIRECT_IO 0 LOCKS 200000 DEF_TABLE_LOCKMODE page RESIDENT 0 SHMBASE 0x700000000000000L SHMVIRTSIZE 512000 SHMADD 256000 EXTSHMADD 8192 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300AUTO_CKPTS 1 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /bkp TAPEBLK 128 TAPESIZE 0 LTAPEDEV /llog/drcallog LTAPEBLK 64 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs DD_HASHSIZE 71 DD_HASHMAX 15 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 64 ALLOW_NEWLINE 0 USELASTCOMMITTED NONE FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000,alice=4 ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY 2048 DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 512 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 0AUTO_REPREPARE 1 RA_PAGES 64 RA_THRESHOLD 16 BATCHEDREAD_TABLE 0 EXPLAIN_STAT 1 #SQLTRACE level=low,ntraces=1000,size=2,mode=global #DBCREATE_PERMISSION informix #DB_LIBRARY_PATH IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 STAGEBLOB OPCACHEMAX 0 SQL_LOGICAL_CHAR OFF SEQ_CACHE_SIZE 10 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE sbs CDR_MAX_DYNAMIC_LOGS 0 CDR_SUPPRESS_ATSRISWARN DRAUTO 0 DRINTERVAL 2 DRTIMEOUT 60 HA_ALIAS drcastxliveca DRLOSTFOUND /llog/drca_dr.lostfound DRIDXAUTO 1 LOG_INDEX_BUILDS 1 SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK TEMPTAB_NOLOG 1 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 DUMPDIR /llog/dump DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh RAS_PLOG_SPEED 0 RAS_LLOG_SPEED 2718 EILSEQ_COMPAT_MODE 0 QSTATS 0 WSTATS 0 LOW_MEMORY_RESERVE 0 LOW_MEMORY_MGR 0 GSKIT_VERSION #VPCLASS jvp,num=1 JVPJAVAHOME $INFORMIXDIR/extend/krakatoa/jre JVPHOME $INFORMIXDIR/extend/krakatoa JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops JVPLOGFILE $INFORMIXDIR/jvp.log #JDKVERSION 1.5 JVPJAVALIB /bin JVPJAVAVM jvm #JVPARGS -verbose:jni#JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g. jar JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 BUFFERPOOL size=4K,buffers=150000,lrus=31,lru_min_dirty=2.000000,lru_max_dirty=5.000000 BUFFERPOOL size=16K,buffers=1000,lrus=6,lru_min_dirty=0.500000,lru_max_dirty=2.000000 AUTO_LRU_TUNING 1

Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message?

Hey, can I please not get these emails anymore it really clogs up my inbox. Thanks! ----- Original Message ----- From: STUART STEPHENS <stuart.stephens@monitorsoft.com> To: ids@iiug.org Sent: Thu, 09 Oct 2014 15:19:22 -0000 (UTC) Subject: Re: RSS not working [33941] Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

why no let me try that. 11:34:46 DR: The configuration parameter LTAPEDEV on the paired servers must be both set to a NULL device or both set to non-NULL (could be different) devices.

I have this working on two other instances same ids ver similar from the RSS -bash-4.2$ onstat -g rss verbose IBM Informix Dynamic Server Version 11.50.FC9 -- Read-Only (RSS) -- Up 8 days 00:49:44 -- 1200896 Kbytes RSS Server control block: 0x700000031591cb8 Local server type: RSS Server Status : Active Source server name: livnostxliveno Connection status: Connected Last log page received(log id,page): 34575,2349 Sequence number of last buffer received: 7874 Sequence number of last buffer acked: 7874

I have RSS running on other instances same ids ver, and aix. -bash-4.2$ onstat -g rss verbose IBM Informix Dynamic Server Version 11.50.FC9 -- Read-Only (RSS) -- Up 8 days 00:49:44 -- 1200896 Kbytes RSS Server control block: 0x700000031591cb8 Local server type: RSS Server Status : Active Source server name: livnostxliveno Connection status: Connected Last log page received(log id,page): 34575,2349 Sequence number of last buffer received: 7874 Sequence number of last buffer acked: 7874

here is a primary that is stuck -bash-4.2$ onstat -g rss verbose IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 7 days 01:55:15 -- 1200896 Kbytes Local server type: Primary Index page logging status: Enabled Index page logging was enabled at: 2014/10/01 15:16:50 Number of RSS servers: 1 RSS Server information: RSS Server control block: 0x700000043c88028 RSS server name: drukstxliveuk RSS server status: Active RSS connection status: Connected RSS flow control:192/176 Log transmission status: Active Next log page to send(log id,page): 198818,0 Last log page acked(log id,page): 0,0 Time of Last Acknowledgement: 2014-10-08.13:29:33 Pending Log Pages to be ACKed: 0 Approximate Log Page Backlog:294065 Sequence number of next buffer to send: 0 Sequence number of last buffer acked: 0 Supports Proxy Writes: N

The only reason that I can think of that might have caused this is if t= he network connection between the primary and the secondary was down for a= n extended period of time and a log wrap occurred. From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/09/2014 11:15 AM Subject: Re: RSS not working [33946] Sent by: ids-bounces@iiug.org here is a primary that is stuck -bash-4.2$ onstat -g rss verbose IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 7 days 01:55:15 -- 1200896 Kbytes Local server type: Primary Index page logging status: Enabled Index page logging was enabled at: 2014/10/01 15:16:50 Number of RSS servers: 1 RSS Server information: RSS Server control block: 0x700000043c88028 RSS server name: drukstxliveuk RSS server status: Active RSS connection status: Connected RSS flow control:192/176 Log transmission status: Active Next log page to send(log id,page): 198818,0 Last log page acked(log id,page): 0,0 Time of Last Acknowledgement: 2014-10-08.13:29:33 Pending Log Pages to be ACKed: 0 Approximate Log Page Backlog:294065 Sequence number of next buffer to send: 0 Sequence number of last buffer acked: 0 Supports Proxy Writes: N ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Interesting the servers are on different subnets across an MPLS wan. And that is the reason I used RSS I have 2 thoughts 1. the L0 backup using ontape it seems that the log is missing and cannot be sent from the primary, I think I'll move the logs to another dir start the ontape L0 then delete the old logs in the new dir. 2. Is the a number of Approximate Log Page Backlog too high is their a limit I am hitting, should I use RSS flow control currently the default sets it at 192/176 I not sure I understand the dynamic of the flow control

It's more likely that a log wrap occurred from the time that you starte= d the backup on the primary and the time that you started the RSS server.= You might want to check in the online log file to see if that occurred.= From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/09/2014 11:43 AM Subject: Re: RSS not working [33948] Sent by: ids-bounces@iiug.org Interesting the servers are on different subnets across an MPLS wan. An= d that is the reason I used RSS I have 2 thoughts 1. the L0 backup using ontape it seems that the log is missing and cann= ot be sent from the primary, I think I'll move the logs to another dir start the ontape L0 then dele= te the old logs in the new dir. 2. Is the a number of Approximate Log Page Backlog too high is their a limit I am hitting, should I use RSS flow control currently the default sets it at 192/176 I not sure I understand the dynamic of the flow control ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

their is a huge amount of time . here are my steps, 1 backup L0 2 gzip the backup 3 copy the backup.gzip to rss server any where from 4 to 10 gigs over wan could be 24 -48 hours 4 unzip on RSS server 5 ontape -p 6 then onmode -d RSS command this could take a min 2 to 3 days. during this time I have suspended backups on the Primary..

The backup checkpoint is done at the start of the backup. That checkpo= int is the RSS starting point. You need to see what log file that checkpoi= nt was done in and if the suspension of log backups was done before that l= og file was backed up. If that log file was archived, then it is possible that it was overwrit= ten during the time that that it took to establish the RSS server. M.P. From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/09/2014 11:57 AM Subject: Re: RSS not working [33950] Sent by: ids-bounces@iiug.org their is a huge amount of time . here are my steps, 1 backup L0 2 gzip the backup 3 copy the backup.gzip to rss server any where from 4 to 10 gigs over w= an could be 24 -48 hours 4 unzip on RSS server 5 ontape -p 6 then onmode -d RSS command this could take a min 2 to 3 days. during this time I have suspended backups on the Primary.. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Yep I think we are saying the same thing. because I'm using ontape -c and my llog go to the tapedev after my bkp finishes i clear my tapedev I'm causing this. AHH i get it my logs so my llogdbs where my logs are LOGFILES 102 LOGSIZE 10000 DYNAMIC_LOGS 0 LOGBUFF 64 which means that after I fill 1 gig they over write. its not reading from the log backup TAPEDEV so I add enough logs and dbs space to carry me till I startup the RSS its reading from the llogsbds not the TAPEDEV and I'm messing up the tape dev also, bc I am delete the dir after the backup finishes. Oh tell me I got it because I'm banging my head on my desk and am likely to pass out

You could speed up the process by combining some of the steps. Instead= of doing... 1 backup L0 2 gzip the backup 3 copy the backup.gzip to rss server any where from 4 to 10 gigs over w= an could be 24 -48 hours 4 unzip on RSS server 5 ontape -p 6 then onmode -d RSS command you could do ontape -t -l0 | gzip > (an IPC pipe) > gunzip | ontape -p If you use an IPC pipe between the two systems, you would be taking the= backup and restoring at the same time. From: "CLAYTON DAIGLE" <cjdaigle2@hotmail.com> To: ids@iiug.org Date: 10/09/2014 12:24 PM Subject: Re: RSS not working [33952] Sent by: ids-bounces@iiug.org Yep I think we are saying the same thing. because I'm using ontape -c and my llog go to the tapedev after my bkp finishes i clear my tapedev I'm causing this. AHH i get it my logs so my llogdbs where my logs are LOGFILES 102 LOGSIZE 10000 DYNAMIC_LOGS 0 LOGBUFF 64 which means that after I fill 1 gig they over write. its not reading fr= om the log backup TAPEDEV so I add enough logs and dbs space to carry me till I startup the RSS i= ts reading from the llogsbds not the TAPEDEV and I'm messing up the tape d= ev also, bc I am delete the dir after the backup finishes. Oh tell me I got it because I'm banging my head on my desk and am likel= y to pass out ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Thank you I going to try this also I'm upgrading my wan backbone tonight from 10 meg to 30 meg ... I am still overwhelmed by the llog and not tapedev misconception I had. IPC pipe in Unix I look into that

Thank You all this is resolved It was a long warp issue adding logs to the ids worked RSS is flowing Thanks to all who helped out

Why not just use ifxclone? I may have missed an older version number or something but isn't that essentially what you're doing just in a long form? That will create the RSS server connections and everything for you. Run the clone while tailing the online.log grepping for (I'm going from memory) "server operational." and have it mail you when it's finished.