HP3000-L Archives

April 2002, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
need to know the true size of a Database log file .
From:
"PATURI,RAMBABU (Non-HP-Singapore,ex1)" <[log in to unmask]>
Reply To:
PATURI,RAMBABU (Non-HP-Singapore,ex1)
Date:
Thu, 18 Apr 2002 17:32:11 +0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (75 lines) 
Hi  List

While viewing logs in sqlutil it does not seem clear how to view how full
the log file is
We have had problems whereas the logs have reached capacity and no new logs
were available to change to.
Any suggestions on how I can see the true size of the file:

FILENAME   CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX

MIMLOG1 PRIV 256W FB 100000 100000 1 200000 5 32


Thanks

Ram

-----Original Message-----
From: Donna Garverick [mailto:[log in to unmask]]
Sent: Thursday, April 18, 2002 5:02 AM
To: [log in to unmask]
Subject: [HP3000-L] allbase error?


hi all!

the following is from a production jobs....

HP36216-02A.G3.04          Interactive SQL/3000
ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO.
1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED.

BEGIN WORK RU;
set autosave 100;
set autocommit on;
set owner IFO;
set pa 1024;
IXD:isql> UPDATE LOC_ORD_CNTL SET PROCESS_TYPE = 'SH ORD
APPLIED'
>  WHERE PROCESS_TYPE = 'SH ORD CREATE'
>    AND PROCESS_TS < '2002-04-16 00:00:00.001';
DBCore internal error on DBEFile -1825357824 - Rollforward
recovery
required.   (DBERR 15066)
The data updated/deleted is in the RC/RU transaction.
(DBWARN 2017)
INSERT/UPDATE/DELETE statement had no effect due to
execution errors.
(DBERR 2292)
Number of rows processed is 0

anybody know anything about this dberr 15066?  is it
documented? (ha)       - d

--
Donna Garverick     Sr. System Programmer
925-210-6631        [log in to unmask]

Come, my friends, 'Tis not too late to seek a newer world.
Tho' much is taken, much abides; and tho'
We are not now that strength which in old days
Moved earth and heaven, that which we are, we are.
"Ulysses", A. Tennyson

>>>MY opinions, not Longs Drug Stores'<<<

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2