Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Could anyone please provide a fix?

Shaun McElreath
Occasional Visitor

Could anyone please provide a fix?

from dbtmp:DB_DBO_TRANS_APPLIER_1513.LOG
( 2-JUL-2008 15:13:20.64)$!
( 2-JUL-2008 15:13:20.64)$ File_to_Stamp = File - "Building_"
( 2-JUL-2008 15:13:20.64)$ If F$Search("DBTRANS:Achg_DBO_TRANS_.Building_ACHG") .NES. "" then Rename/Log DBTRANS:Achg`
%RENAME-I-RENAMED, DB$ROOT:[TRANS]ACHG_DBO_TRANS_.BUILDING_ACHG;1 renamed to DB$ROOT:[TRANS]ACHG_DBO_TRANS_.ACHG;1
( 2-JUL-2008 15:13:20.66)$ If F$Search("DBTRANS:Achg_DBO_TRANS_.ACHG") .NES. "" then @UTIL:STAMP_FILE DBTRANS:Achg_DBO_TRANS_`
( 2-JUL-2008 15:13:20.66)$ OldVer = F$Verify(0)
%RENAME-E-OPENOUT, error opening DB$ROOT:[TRANS]ACHG_DBO_TRANS__2JUL200815130241.ACHG; as output
-RMS-E-ENT, ACP enter function failed
-SYSTEM-W-DIRALLOC, allocation failure on directory file
%SYSTEM-F-ABORT, abort
PROD_DB job terminated at 2-JUL-2008 15:13:20.74
and
from dbtmp:DB_ENRC_EXTRACT.LOG

????????????????????????????????????????
?Cannot open file opening file
DBTRANS:CA_DB_ENRC_PA.BUILDING_CA_UPDATE_CLCT
VMS Error: 114698
????????????????????????????????????????
%RMS-F-CRE, ACP file create failed


NRCAVA::Theresa's:::>sh dev dbtrans

Device Device Error Volume Free Trans Mnt
Name Status Count Label Blocks Count Cnt
$1$DGA247: (NRCAVA) Mounted 0 RMADSK02 35151875 229 1
---------------------------------------

another instance

Entry Jobname Username Status
----- ------- -------- ------
3508 DB_ENRC_EXTRACT PROD_DB Retained on error
%SYSTEM-F-ABORT, abort
Completed 2-JUL-2008 14:45:24.08 on queue SYS$BATCH_NRCAVA
Mopr_HouAVA>edit/read dbtmp:db_enrc_extract.log
1 $ SET NOON
*c
----- MOVE_SCAN_FILE checkpointed into CLUSTER_WRITABLE:DB_TRANS_APPLIER_DB_ENR♦
( 2-JUL-2008 14:45:24.06)$ Exit
( 2-JUL-2008 14:45:24.06)$!----------------------------------------------------♦
( 2-JUL-2008 14:45:24.06)$! Copy the file into the location needed by the SCN s♦
( 2-JUL-2008 14:45:24.06)$! 17-Dec-2007 TAS Removing SCNTRANS: f♦
( 2-JUL-2008 14:45:24.06)$! to now copy to STTRA♦
( 2-JUL-2008 14:45:24.06)$! Process the ETC_Trans_File so it is all♦
( 2-JUL-2008 14:45:24.06)$! ST system. This will mirror what occur♦
( 2-JUL-2008 14:45:24.06)$! outbound ST file for ST file generation.
( 2-JUL-2008 14:45:24.06)$!----------------------------------------------------♦
( 2-JUL-2008 14:45:24.06)$! Copy 'ETC_Trans_File'SCNTRANS:DB_'Tag'_SCN_TR♦
( 2-JUL-2008 14:45:24.06)$ Copy DBTRANS:ETC_DB_ENRC_PA.Building_ETC_TRANS♦
%COPY-E-OPENIN, error opening DB$ROOT:[TRANS]ETC_DB_ENRC_PA.BUILDING_ETC_TRANS;♦
-RMS-E-FNF, file not found
%SYSTEM-F-ABORT, abort
PROD_DB job terminated at 2-JUL-2008 14:45:24.07
Accounting information:
Buffered I/O count: 7375 Peak working set size: 25008
Direct I/O count: 18672 Peak virtual size: 220416
Page faults: 10338 Mounted volumes: 0
2 REPLIES
Hoff
Honored Contributor

Re: Could anyone please provide a fix?

The DFU (Freeware) tool and DFO (commercial) can tell you if your disk is (as it appears) too fragmented.

There are a couple of different versions of DFU around, depending on which OpenVMS version is in use here.

See how big the directory is, and if you have enough room for it on your disk. (Total disk free space is almost always far greater than contiguous free space, FWIW.)

--
$ HELP /MESSAGE DIRALLOC

DIRALLOC, allocation failure on directory file

Facility: SYSTEM, System Services

Explanation: The file system failed to allocate space to increase the
size of a directory file. Because directory files must be
contiguous, this error might be caused by the disk being
full. More likely, there is not enough contiguous space on
the disk for the directory, so the free disk space is being
fragmented.

User Action: Reorganize the free disk space by copying it with the Backup
utility, or restructure your application to use a larger
number of smaller directories.

--

I'd probably get somebody in to look at system operations and procedures, too. OpenVMS can run pretty well all by itself, but eventually most applications tend to go off the rails somehow. Contiguous space, fragmentation, too much cruft in a directory file, the ;32767 file version limit, data archival errors or omissions, etc...

Stephen Hoffman
HoffmanLabs LLC
Hein van den Heuvel
Honored Contributor

Re: Could anyone please provide a fix?


>> Could anyone please provide a fix?

No. There is nothing really broken.
But YOU can resolve the problem.
Just clean up the directory: DB$ROOT:[TRANS]
After he cleanup you _may_ have to compress the directory using DFU or a RENAME sequence.

And while you are at it.. clean that disk DB$ROOT over all.

Enjoy!
Hein.