ontape -a "this tape contains no log data"
A user on IDS 11.10.UC1 (Red Hat Linux) found that 'ontape -a' for logical log backups failed immediately with "This tape contains no log data", with nothing logged in online.log. He posted onstat -l/-m output and his settings (TAPEDEV /p1/copia/dat.000, LTAPEDEV apparently /p1/copia/log.000, TAPEBLK 32, LTAPESIZE 2000000). Suggestions: set TAPEDEV/LTAPEDEV to a directory rather than a file in version 11 (so no tape-mount prompt appears), and check that the LTAPEDEV file exists, is owned by informix with 660 permissions, and is empty — Art Kagel suspected ontape refused to overwrite a non-empty file containing non-log data, advising to zero or rename it, else call support. No confirmation from the poster is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, informix gurus
today, to do "ontape -a", the system show me the follow message:
"this tape contains no log data"
Program over.
This are my settings
. Red hat linux 5.1
. IDS 11.10.UC1
The online.log do not show nothing.
the log file is empty before to do ontape.
I only keep 3 logical logs available.
what I do ?
Thanks for your help
_________________________________________________________________
alberto rodriguez wrote:
> Hello, informix gurus
>
> today, to do "ontape -a", the system show me the follow message:
>
> "this tape contains no log data"
>
> Program over.
>
> This are my settings
> .. Red hat linux 5.1
> .. IDS 11.10.UC1
>
> The online.log do not show nothing.
> the log file is empty before to do ontape.
> I only keep 3 logical logs available.
>
> what I do ?
Pray for a miracle?
--
Cheers,
Obnoxio The Clown
http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
What does onstat -l report? Post the output.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Dec 9, 2009 at 1:08 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
> Hello, informix gurus
>
> today, to do "ontape -a", the system show me the follow message:
>
> "this tape contains no log data"
>
> Program over.
>
> This are my settings
> .. Red hat linux 5.1
> .. IDS 11.10.UC1
>
> The online.log do not show nothing.
> the log file is empty before to do ontape.
> I only keep 3 logical logs available.
>
> what I do ?
> Thanks for your help
>
> _________________________________________________________________
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00151747beea23144e047a4fa53e
hello mr kagel,
this is my current onstat -l,
as you can see, my system do replicate, perhaps this info be important
IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10 days
22:23:40 -- 324128 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 43 64 2129734 36287 58.69
phybegin physize phypos phyused %used
1:263 500000 216888 1933 0.39
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 64 33849794 3684479 2919617 9.2 1.3
Subsystem numrecs Log Space used
OLDRSAM 33849480 2438596296
CLONE 314 11304
address number flags uniqid begin size used %used
457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
457ccda8 3 U---C-L 1286 1:800263 150000 84484 56.32
457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
12 active, 12 total
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape -a "this tape contains no log data" [18324]
> Date: Wed, 9 Dec 2009 13:13:37 -0500
>
> What does onstat -l report? Post the output.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Dec 9, 2009 at 1:08 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
>
> > Hello, informix gurus
> >
> > today, to do "ontape -a", the system show me the follow message:
> >
> > "this tape contains no log data"
> >
> > Program over.
> >
> > This are my settings
> > .. Red hat linux 5.1
> > .. IDS 11.10.UC1
> >
> > The online.log do not show nothing.
> > the log file is empty before to do ontape.
> > I only keep 3 logical logs available.
> >
> > what I do ?
> > Thanks for your help
> >
> > _________________________________________________________________
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00151747beea23144e047a4fa53e
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape -a
again and post the command session output and the output from onstat -m and
onstat -l after that finishes?
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
> hello mr kagel,
>
> this is my current onstat -l,
> as you can see, my system do replicate, perhaps this info be important
>
> IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> days
> 22:23:40 -- 324128 Kbytes
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-1 43 64 2129734 36287 58.69
>
> phybegin physize phypos phyused %used
>
> 1:263 500000 216888 1933 0.39
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> L-2 0 64 33849794 3684479 2919617 9.2 1.3
>
> Subsystem numrecs Log Space used
>
> OLDRSAM 33849480 2438596296
>
> CLONE 314 11304
>
> address number flags uniqid begin size used %used
> 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> 457ccda8 3 U---C-L 1286 1:800263 150000 84484 56.32
> 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> 12 active, 12 total
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: ontape -a "this tape contains no log data" [18324]
> > Date: Wed, 9 Dec 2009 13:13:37 -0500
> >
> > What does onstat -l report? Post the output.
> >
> > Art
> >
> > Art S. Kagel
> > Oninit (www.oninit.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > See you at the 2010 IIUG Informix Conference
> > April 25-28, 2010
> > Overland Park (Kansas City), KS
> > www.iiug.org/conf
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> > with which I am associated either explicitly or implicitly. Neither do
> > those opinions reflect those of other individuals affiliated with any
> entity
> > with which I am affiliated nor those of the entities themselves.
> >
> > On Wed, Dec 9, 2009 at 1:08 PM, alberto rodriguez <sqlweb@hotmail.com
> >wrote:
> >
> > > Hello, informix gurus
> > >
> > > today, to do "ontape -a", the system show me the follow message:
> > >
> > > "this tape contains no log data"
> > >
> > > Program over.
> > >
> > > This are my settings
> > > .. Red hat linux 5.1
> > > .. IDS 11.10.UC1
> > >
> > > The online.log do not show nothing.
> > > the log file is empty before to do ontape.
> > > I only keep 3 logical logs available.
> > >
> > > what I do ?
> > > Thanks for your help
> > >
> > > _________________________________________________________________
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --00151747beea23144e047a4fa53e
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015174769c88a0ff0047a4feb7e
TAPEDEV /p1/copia/dat.000
TAPEBLK 32
LTAPESIZE 2000000
this is the output of ontape -a, onstat -m and onstat -l :
ontape -a
Performing automatic backup of logical logs.
Please mount tape 1 on /p1/copia/log.000 and press Return to continue ...
This tape contains no log data
onstat -m:
IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10 days
22:46:24 -- 324128 Kbytes
Message Log File: /d1/informix/online.log11:13:10 Checkpoint Completed: duration was 1 seconds.
11:13:10 Wed Dec 9 - loguniq 1286, logpos 0xf941018, timestamp: 0x5e28c002
Interval: 20560
11:13:10 Maximum server connections 196
11:13:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 4,
Plog used 9411, Llog used 26737
11:16:33 Adjusting LRU for bufferpool - id 0 size 2k
11:16:33 Old max 22.0 min 18.3 New max 21.7 min 18.1
12:03:23 Checkpoint Completed: duration was 1 seconds.
12:03:23 Wed Dec 9 - loguniq 1286, logpos 0x11fbc018, timestamp: 0x5e63a604
Interval: 20561
12:03:23 Maximum server connections 196
12:03:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0,
Plog used 3986, Llog used 9851
12:53:37 Checkpoint Completed: duration was 1 seconds.
12:53:37 Wed Dec 9 - loguniq 1286, logpos 0x13ba8018, timestamp: 0x5e9205df
Interval: 20562
12:53:37 Maximum server connections 196
12:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0,
Plog used 1519, Llog used 7148
onstat -l:
IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10 days
22:46:35 -- 324128 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 6 64 2131141 36322 58.67
phybegin physize phypos phyused %used
1:263 500000 218372 3380 0.68
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 64 33876397 3689806 2924623 9.2 1.3
Subsystem numrecs Log Space used
OLDRSAM 33876083 2440630840
CLONE 314 11304
address number flags uniqid begin size used %used
457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
457ccda8 3 U---C-L 1286 1:800263 150000 89808 59.87
457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
12 active, 12 total
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape -a "this tape contains no log data" [18327]
> Date: Wed, 9 Dec 2009 13:33:09 -0500
>
> What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape -a
> again and post the command session output and the output from onstat -m and
> onstat -l after that finishes?>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
>
> > hello mr kagel,
> >
> > this is my current onstat -l,
> > as you can see, my system do replicate, perhaps this info be important
> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> > days
> > 22:23:40 -- 324128 Kbytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-1 43 64 2129734 36287 58.69
> >
> > phybegin physize phypos phyused %used
> >
> > 1:263 500000 216888 1933 0.39
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > L-2 0 64 33849794 3684479 2919617 9.2 1.3
> >
> > Subsystem numrecs Log Space used
> >
> > OLDRSAM 33849480 2438596296
> >
> > CLONE 314 11304
> >
> > address number flags uniqid begin size used %used
> > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> > 457ccda8 3 U---C-L 1286 1:800263 150000 84484 56.32
> > 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> > 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> > 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> > 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> > 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> > 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> > 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> > 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> > 12 active, 12 total
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: ontape -a "this tape contains no log data" [18324]
> > > Date: Wed, 9 Dec 2009 13:13:37 -0500
> > >
> > > What does onstat -l report? Post the output.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Oninit (www.oninit.com)
> > > IIUG Board of Directors (art@iiug.org)
> > >
> > > See you at the 2010 IIUG Informix Conference
> > > April 25-28, 2010
> > > Overland Park (Kansas City), KS
> > > www.iiug.org/conf
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and
> > > do not reflect on my employer, Oninit, the IIUG, nor any other
> > organization
> > > with which I am associated either explicitly or implicitly. Neither do
> > > those opinions reflect those of other individuals affiliated with any
> > entity
> > > with which I am affiliated nor those of the entities themselves.
> > >
> > > On Wed, Dec 9, 2009 at 1:08 PM, alberto rodriguez <sqlweb@hotmail.com
> > >wrote:
> > >
> > > > Hello, informix gurus
> > > >
> > > > today, to do "ontape -a", the system show me the follow message:
> > > >
> > > > "this tape contains no log data"
> > > >
> > > > Program over.
> > > >
> > > > This are my settings
> > > > .. Red hat linux 5.1
> > > > .. IDS 11.10.UC1
> > > >
> > > > The online.log do not show nothing.
> > > > the log file is empty before to do ontape.
> > > > I only keep 3 logical logs available.
> > > >
> > > > what I do ?
> > > > Thanks for your help
> > > >
> > > > _________________________________________________________________
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
********************************************
This is IDS version 11.
The first thing I see is your TAPEDEV setting.
TAPEDEV should be set to a directory instead of a file.
If that's your TAPEDEV setting, I'll assume that LTAPEDEV is set the same.
Try setting them both to directories and see what happens. You shouldn't
be getting the prompt to mount the tape.
Best regards,
Mike
Mike Lowe
Education Offering Development
IBM Software Group
Tel: 303-225-5440
Email: mike.lowe@us.ibm.com
"alberto rodriguez" <sqlweb@hotmail.com>
Sent by: ids-bounces@iiug.org
12/09/09 11:47 AM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
RE: ontape -a "this tape contains no log data" [18328]
TAPEDEV /p1/copia/dat.000
TAPEBLK 32
LTAPESIZE 2000000
this is the output of ontape -a, onstat -m and onstat -l :
ontape -a
Performing automatic backup of logical logs.
Please mount tape 1 on /p1/copia/log.000 and press Return to continue ...
This tape contains no log data
onstat -m:
IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10days
22:46:24 -- 324128 Kbytes
Message Log File: /d1/informix/online.log
11:13:10 Checkpoint Completed: duration was 1 seconds.
11:13:10 Wed Dec 9 - loguniq 1286, logpos 0xf941018, timestamp: 0x5e28c002
Interval: 20560
11:13:10 Maximum server connections 196
11:13:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
4,
Plog used 9411, Llog used 26737
11:16:33 Adjusting LRU for bufferpool - id 0 size 2k
11:16:33 Old max 22.0 min 18.3 New max 21.7 min 18.1
12:03:23 Checkpoint Completed: duration was 1 seconds.
12:03:23 Wed Dec 9 - loguniq 1286, logpos 0x11fbc018, timestamp:
0x5e63a604
Interval: 20561
12:03:23 Maximum server connections 196
12:03:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0,
Plog used 3986, Llog used 9851
12:53:37 Checkpoint Completed: duration was 1 seconds.
12:53:37 Wed Dec 9 - loguniq 1286, logpos 0x13ba8018, timestamp:
0x5e9205df
Interval: 20562
12:53:37 Maximum server connections 196
12:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0,
Plog used 1519, Llog used 7148
onstat -l:
IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10days
22:46:35 -- 324128 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 6 64 2131141 36322 58.67
phybegin physize phypos phyused %used
1:263 500000 218372 3380 0.68
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 64 33876397 3689806 2924623 9.2 1.3
Subsystem numrecs Log Space used
OLDRSAM 33876083 2440630840
CLONE 314 11304
address number flags uniqid begin size used %used
457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
457ccda8 3 U---C-L 1286 1:800263 150000 89808 59.87
457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
12 active, 12 total
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape -a "this tape contains no log data" [18327]
> Date: Wed, 9 Dec 2009 13:33:09 -0500
>
> What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape
-a
> again and post the command session output and the output from onstat -m
and
> onstat -l after that finishes?>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> do not reflect on my employer, Oninit, the IIUG, nor any other
organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any
entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez
<sqlweb@hotmail.com>wrote:
>
> > hello mr kagel,
> >
> > this is my current onstat -l,
> > as you can see, my system do replicate, perhaps this info be important
> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up10
> > days
> > 22:23:40 -- 324128 Kbytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-1 43 64 2129734 36287 58.69
> >
> > phybegin physize phypos phyused %used
> >
> > 1:263 500000 216888 1933 0.39
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > L-2 0 64 33849794 3684479 2919617 9.2 1.3
> >
> > Subsystem numrecs Log Space used
> >
> > OLDRSAM 33849480 2438596296
> >
> > CLONE 314 11304
> >
> > address number flags uniqid begin size used %used
> > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> > 457ccda8 3 U---C-L 1286 1:800263 150000 84484 56.32
> > 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> > 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> > 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> > 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> > 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> > 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> > 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> > 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> > 12 active, 12 total
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: ontape -a "this tape contains no log data" [18324]
> > > Date: Wed, 9 Dec 2009 13:13:37 -0500
> > >
> > > What does onstat -l report? Post the output.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Oninit (www.oninit.com)
> > > IIUG Board of Directors (art@iiug.org)
> > >
> > > See you at the 2010 IIUG Informix Conference
> > > April 25-28, 2010
> > > Overland Park (Kansas City), KS
> > > www.iiug.org/conf
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> > and
> > > do not reflect on my employer, Oninit, the IIUG, nor any other
> > organization
> > > with which I am associated either explicitly or implicitly. Neither
do
> > > those opinions reflect those of other individuals affiliated with
any
> > entity
> > > with which I am affiliated nor those of the entities themselves.
> > >
> > > On Wed,
Well, you didn't show LTAPEDEV, but I can guess that from the ontape -a
output:
LTAPEDEV /p1/copia/log.000
Does that file exist? Are its permissions 660 and owned by 'informix' and
group 'informix'? Is it empty? If not fix that and try again.
WAIT! I JUST FIGURED IT OUT! The file, /p1/copia/log.000, isn't empty and
it contains data or text which does not look like logical log records, so
ontape doesn't want to overwrite it in case you need the existing contents!
Zero out the file, or rename it and create a new empty file and try again.
If that's all OK, contact tech support.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Dec 9, 2009 at 1:47 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
> TAPEDEV /p1/copia/dat.000
> TAPEBLK 32
> LTAPESIZE 2000000>
> this is the output of ontape -a, onstat -m and onstat -l :
>
> ontape -a>
> Performing automatic backup of logical logs.
>
> Please mount tape 1 on /p1/copia/log.000 and press Return to continue ...
>
> This tape contains no log data
>
> onstat -m:>
> IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> days
> 22:46:24 -- 324128 Kbytes
>
> Message Log File: /d1/informix/online.log
> 11:13:10 Checkpoint Completed: duration was 1 seconds.
> 11:13:10 Wed Dec 9 - loguniq 1286, logpos 0xf941018, timestamp: 0x5e28c002
> Interval: 20560
>
> 11:13:10 Maximum server connections 196
> 11:13:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 4,
> Plog used 9411, Llog used 26737
>
> 11:16:33 Adjusting LRU for bufferpool - id 0 size 2k
> 11:16:33 Old max 22.0 min 18.3 New max 21.7 min 18.1
> 12:03:23 Checkpoint Completed: duration was 1 seconds.
> 12:03:23 Wed Dec 9 - loguniq 1286, logpos 0x11fbc018, timestamp: 0x5e63a604
> Interval: 20561
>
> 12:03:23 Maximum server connections 196
> 12:03:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3986, Llog used 9851
>
> 12:53:37 Checkpoint Completed: duration was 1 seconds.
> 12:53:37 Wed Dec 9 - loguniq 1286, logpos 0x13ba8018, timestamp: 0x5e9205df
> Interval: 20562
>
> 12:53:37 Maximum server connections 196
> 12:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 1519, Llog used 7148
>
> onstat -l:>
> IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> days
> 22:46:35 -- 324128 Kbytes
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-2 6 64 2131141 36322 58.67
>
> phybegin physize phypos phyused %used
>
> 1:263 500000 218372 3380 0.68
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> L-1 0 64 33876397 3689806 2924623 9.2 1.3
>
> Subsystem numrecs Log Space used
>
> OLDRSAM 33876083 2440630840
>
> CLONE 314 11304
>
> address number flags uniqid begin size used %used
> 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> 457ccda8 3 U---C-L 1286 1:800263 150000 89808 59.87
> 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> 12 active, 12 total
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: ontape -a "this tape contains no log data" [18327]
> > Date: Wed, 9 Dec 2009 13:33:09 -0500
> >
> > What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape -a
> > again and post the command session output and the output from onstat -m
> and
> > onstat -l after that finishes?> >
> > Art
> >
> > Art S. Kagel
> > Oninit (www.oninit.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > See you at the 2010 IIUG Informix Conference
> > April 25-28, 2010
> > Overland Park (Kansas City), KS
> > www.iiug.org/conf
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> > with which I am associated either explicitly or implicitly. Neither do
> > those opinions reflect those of other individuals affiliated with any
> entity
> > with which I am affiliated nor those of the entities themselves.
> >
> > On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez <sqlweb@hotmail.com
> >wrote:
> >
> > > hello mr kagel,
> > >
> > > this is my current onstat -l,
> > > as you can see, my system do replicate, perhaps this info be important
> > >
> > > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up> 10
> > > days
> > > 22:23:40 -- 324128 Kbytes
> > >
> > > Physical Logging
> > > Buffer bufused bufsize numpages numwrits pages/io
> > > P-1 43 64 2129734 36287 58.69
> > >
> > > phybegin physize phypos phyused %used
> > >
> > > 1:263 500000 216888 1933 0.39
> > >
> > > Logical Logging
> > > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > > L-2 0 64 33849794 3684479 2919617 9.2 1.3
> > >
> > > Subsystem numrecs Log Space used
> > >
> > > OLDRSAM 33849480 2438596296
> > >
> > > CLONE 314 11304
> > >
> > > address number flags uniqid begin size used %used
> > > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > > 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> > > 457ccda8 3 U---C-L 1286 1:800263 150000 84484 56.32
> > > 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> > > 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> > > 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> > > 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> > > 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> > > 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> > > 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> > > 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> > > 12 active, 12 total
> > >
> > > > To: ids@iiug.org
> > > > From: art.kagel@gmail.com
> > > > Subject: Re: ontape -a "this tape contains no log data" [18324]
> > > > Date: Wed, 9 Dec 2009 13:13:37 -0500
> > > >
Hi mr Kagel,
In truth the file is well, it has correct permissions and is empty
before the ontape -a. There was a process that it blocked to ontape -a, only
was to kill several sessions (onmode - z) of informix
user and the problem was solved.
Thanks for your help
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape -a "this tape contains no log data" [18334]
> Date: Wed, 9 Dec 2009 17:07:29 -0500
>
> Well, you didn't show LTAPEDEV, but I can guess that from the ontape -a
> output:
>
> LTAPEDEV /p1/copia/log.000>
> Does that file exist? Are its permissions 660 and owned by 'informix' and
> group 'informix'? Is it empty? If not fix that and try again.
>
> WAIT! I JUST FIGURED IT OUT! The file, /p1/copia/log.000, isn't empty and
> it contains data or text which does not look like logical log records, so
> ontape doesn't want to overwrite it in case you need the existing contents!
> Zero out the file, or rename it and create a new empty file and try again.
>
> If that's all OK, contact tech support.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Dec 9, 2009 at 1:47 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
>
> > TAPEDEV /p1/copia/dat.000
> > TAPEBLK 32
> > LTAPESIZE 2000000> >
> > this is the output of ontape -a, onstat -m and onstat -l :
> >
> > ontape -a> >
> > Performing automatic backup of logical logs.
> >
> > Please mount tape 1 on /p1/copia/log.000 and press Return to continue ...
> >
> > This tape contains no log data
> >
> > onstat -m:> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> > days
> > 22:46:24 -- 324128 Kbytes
> >
> > Message Log File: /d1/informix/online.log
> > 11:13:10 Checkpoint Completed: duration was 1 seconds.
> > 11:13:10 Wed Dec 9 - loguniq 1286, logpos 0xf941018, timestamp: 0x5e28c002
> > Interval: 20560
> >
> > 11:13:10 Maximum server connections 196
> > 11:13:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 4,
> > Plog used 9411, Llog used 26737
> >
> > 11:16:33 Adjusting LRU for bufferpool - id 0 size 2k
> > 11:16:33 Old max 22.0 min 18.3 New max 21.7 min 18.1
> > 12:03:23 Checkpoint Completed: duration was 1 seconds.
> > 12:03:23 Wed Dec 9 - loguniq 1286, logpos 0x11fbc018, timestamp: 0x5e63a604
> > Interval: 20561
> >
> > 12:03:23 Maximum server connections 196
> > 12:03:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 0,
> > Plog used 3986, Llog used 9851
> >
> > 12:53:37 Checkpoint Completed: duration was 1 seconds.
> > 12:53:37 Wed Dec 9 - loguniq 1286, logpos 0x13ba8018, timestamp: 0x5e9205df
> > Interval: 20562
> >
> > 12:53:37 Maximum server connections 196
> > 12:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 0,
> > Plog used 1519, Llog used 7148
> >
> > onstat -l:> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> > days
> > 22:46:35 -- 324128 Kbytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-2 6 64 2131141 36322 58.67
> >
> > phybegin physize phypos phyused %used
> >
> > 1:263 500000 218372 3380 0.68
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > L-1 0 64 33876397 3689806 2924623 9.2 1.3
> >
> > Subsystem numrecs Log Space used
> >
> > OLDRSAM 33876083 2440630840
> >
> > CLONE 314 11304
> >
> > address number flags uniqid begin size used %used
> > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> > 457ccda8 3 U---C-L 1286 1:800263 150000 89808 59.87
> > 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> > 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> > 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> > 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> > 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> > 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> > 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> > 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> > 12 active, 12 total
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: ontape -a "this tape contains no log data" [18327]
> > > Date: Wed, 9 Dec 2009 13:33:09 -0500
> > >
> > > What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape -a
> > > again and post the command session output and the output from onstat -m
> > and
> > > onstat -l after that finishes?> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Oninit (www.oninit.com)
> > > IIUG Board of Directors (art@iiug.org)
> > >
> > > See you at the 2010 IIUG Informix Conference
> > > April 25-28, 2010
> > > Overland Park (Kansas City), KS
> > > www.iiug.org/conf
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and
> > > do not reflect on my employer, Oninit, the IIUG, nor any other
> > organization
> > > with which I am associated either explicitly or implicitly. Neither do
> > > those opinions reflect those of other individuals affiliated with any
> > entity
> > > with which I am affiliated nor those of the entities themselves.
> > >
> > > On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez <sqlweb@hotmail.com
> > >wrote:
> > >
> > > > hello mr kagel,
> > > >
> > > > this is my current onstat -l,
> > > > as you can see, my system do replicate, perhaps this info be important
> > > >
> > > > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up> > 10
> > > > days
> > > > 22:23:40 -- 324128 Kbytes
> > > >
> > > > Physical Logging
> > > > Buffer bufused bufsize numpages numwrits pages/io
> > > > P-1 43 64 2129734 36287 58.69
> > > >
> > > > phybegin physize phypos phyused %used
> > > >
> > > > 1:263 500000 216888 1933 0.39
> > > >
> > > > Logical Logging
> > > > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > > > L-2 0 64 33849794 3684479 2919617 9.2 1.3
> > > >
> > > > Subsystem numrecs Log Space used
> > > >
> > > > OLDRSAM 33849480 2438596296
> > > >
> > > > CLONE 314 11304
> > > >
> > > > address number flags uniqid begin size used %used
> > > > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > > > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > > > 457ccd60 5 U------ 1285 3:150053 150
My ideas :
- Try to change LTAPEDEV to other path , and run "ontape -a" again
- ps -ef |grep ontape (to find hanging process, then kill it)
- link that LTAPEDEV to /dev/null to make sure there's no file system problem
- did u try to restart IDS engine ?
Best Regards,
Jakkrit A.
________________________________
From: alberto rodriguez <sqlweb@hotmail.com>
To: ids@iiug.org
Sent: Thu, December 10, 2009 8:13:37 PM
Subject: RE: ontape -a "this tape contains no log data" [18339]
Hi mr Kagel,
In truth the file is well, it has correct permissions and is empty
before the ontape -a. There was a process that it blocked to ontape -a, only
was to kill several sessions (onmode - z) of informix
user and the problem was solved.
Thanks for your help
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape -a "this tape contains no log data" [18334]
> Date: Wed, 9 Dec 2009 17:07:29 -0500
>
> Well, you didn't show LTAPEDEV, but I can guess that from the ontape -a
> output:
>
> LTAPEDEV /p1/copia/log.000>
> Does that file exist? Are its permissions 660 and owned by 'informix' and
> group 'informix'? Is it empty? If not fix that and try again.
>
> WAIT! I JUST FIGURED IT OUT! The file, /p1/copia/log.000, isn't empty and
> it contains data or text which does not look like logical log records, so
> ontape doesn't want to overwrite it in case you need the existing contents!
> Zero out the file, or rename it and create a new empty file and try again.
>
> If that's all OK, contact tech support.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Dec 9, 2009 at 1:47 PM, alberto rodriguez <sqlweb@hotmail.com>wrote:
>
> > TAPEDEV /p1/copia/dat.000
> > TAPEBLK 32
> > LTAPESIZE 2000000> >
> > this is the output of ontape -a, onstat -m and onstat -l :
> >
> > ontape -a> >
> > Performing automatic backup of logical logs.
> >
> > Please mount tape 1 on /p1/copia/log.000 and press Return to continue ...
> >
> > This tape contains no log data
> >
> > onstat -m:> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> > days
> > 22:46:24 -- 324128 Kbytes
> >
> > Message Log File: /d1/informix/online.log
> > 11:13:10 Checkpoint Completed: duration was 1 seconds.
> > 11:13:10 Wed Dec 9 - loguniq 1286, logpos 0xf941018, timestamp: 0x5e28c002
> > Interval: 20560
> >
> > 11:13:10 Maximum server connections 196
> > 11:13:10 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 4,
> > Plog used 9411, Llog used 26737
> >
> > 11:16:33 Adjusting LRU for bufferpool - id 0 size 2k
> > 11:16:33 Old max 22.0 min 18.3 New max 21.7 min 18.1
> > 12:03:23 Checkpoint Completed: duration was 1 seconds.
> > 12:03:23 Wed Dec 9 - loguniq 1286, logpos 0x11fbc018, timestamp:
0x5e63a604
> > Interval: 20561
> >
> > 12:03:23 Maximum server connections 196
> > 12:03:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 0,
> > Plog used 3986, Llog used 9851
> >
> > 12:53:37 Checkpoint Completed: duration was 1 seconds.
> > 12:53:37 Wed Dec 9 - loguniq 1286, logpos 0x13ba8018, timestamp:
0x5e9205df
> > Interval: 20562
> >
> > 12:53:37 Maximum server connections 196
> > 12:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> > 0,
> > Plog used 1519, Llog used 7148
> >
> > onstat -l:> >
> > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up 10> > days
> > 22:46:35 -- 324128 Kbytes
> >
> > Physical Logging
> > Buffer bufused bufsize numpages numwrits pages/io
> > P-2 6 64 2131141 36322 58.67
> >
> > phybegin physize phypos phyused %used
> >
> > 1:263 500000 218372 3380 0.68
> >
> > Logical Logging
> > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> > L-1 0 64 33876397 3689806 2924623 9.2 1.3
> >
> > Subsystem numrecs Log Space used
> >
> > OLDRSAM 33876083 2440630840
> >
> > CLONE 314 11304
> >
> > address number flags uniqid begin size used %used
> > 457cccd0 1 U------ 1283 1:500263 150000 150000 100.00
> > 457ccd18 2 U------ 1284 1:650263 150000 150000 100.00
> > 457ccd60 5 U------ 1285 3:150053 150000 150000 100.00
> > 457ccda8 3 U---C-L 1286 1:800263 150000 89808 59.87
> > 457ccdf0 4 U-B---- 1275 3:53 150000 150000 100.00
> > 457cce38 6 U-B---- 1276 3:300053 150000 150000 100.00
> > 457cce80 7 U-B---- 1277 3:450053 150000 150000 100.00
> > 457ccec8 8 U------ 1278 3:600053 150000 150000 100.00
> > 457ccf10 9 U------ 1279 3:750053 150000 150000 100.00
> > 457ccf58 10 U------ 1280 3:900053 150000 150000 100.00
> > 457ccfa0 11 U------ 1281 3:1050053 150000 150000 100.00
> > 45707d38 12 U------ 1282 3:1200053 150000 150000 100.00
> > 12 active, 12 total
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: ontape -a "this tape contains no log data" [18327]
> > > Date: Wed, 9 Dec 2009 13:33:09 -0500
> > >
> > > What do you have LTAPEDEV and LTAPESIZE set to? Can you try the ontape
-a
> > > again and post the command session output and the output from onstat -m
> > and
> > > onstat -l after that finishes?> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Oninit (www.oninit.com)
> > > IIUG Board of Directors (art@iiug.org)
> > >
> > > See you at the 2010 IIUG Informix Conference
> > > April 25-28, 2010
> > > Overland Park (Kansas City), KS
> > > www.iiug.org/conf
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and
> > > do not reflect on my employer, Oninit, the IIUG, nor any other
> > organization
> > > with which I am associated either explicitly or implicitly. Neither do
> > > those opinions reflect those of other individuals affiliated with any
> > entity
> > > with which I am affiliated nor those of the entities themselves.
> > >
> > > On Wed, Dec 9, 2009 at 1:24 PM, alberto rodriguez <sqlweb@hotmail.com
> > >wrote:
> > >
> > > > hello mr kagel,
> > > >
> > > > this is my current onstat -l,
> > > > as you can see, my system do replicate, perhaps this info be important
> > > >
> > > > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line (Prim) -- Up> > 10
> > > > days
> > > > 22:23:40 -- 324128 Kbytes
> > > >
> > > > Physical Logging
> > > > Buffer bufused bufsize numpages numwrits pages/io
> > > > P-1 43 64 2129734 36287 58.69
> > > >
> > > > phybegin physize phypos phyused %used
> > > >
> > > > 1:263 500000 216888 1933 0.39@@N