%CONVERT-F-CREA_ERR, error creating work file CONVWORK

[Pradeep Nair_1]

I have a .com file, which has the following entries.

$conv/fdl=sys$input/fast XX$ABC_DATA:auto_upd.dat XX$ABC_DATA:auto_upd_idx.dat

FILE
ORGANIZATION indexed
BUCKET_SIZE 4

KEY 0
DUPLICATES yes
SEG0_LENGTH 11
SEG0_POSITION 513

But when i try to execute this com file, i'm getting the following error.

%CONVERT-F-CREA_ERR, error creating work file CONVWORK
-RMS-E-CRE, ACP file create failed
-SYSTEM-F-EXDISKQUOTA, disk quota exceeded.

I checked the XX$ABC_DATA device and there is no disk quota enabled. From the error i could see that the command gives me error in creating a Work file. I would like to take help from someone to resolve this error and where to check the location of CONWORK file.

[labadie_1]

What is the size in blocks of your file XX$ABC_DATA:auto_upd.dat ?

how much free space do you have on the device XX$ABC_DATA, and how much contiguous free space ?

Can you post
$ show logical conv*
$ show logical sort*

You should have 3 to 4 times more free space than the size of your input file.

[Pradeep Nair_1]

Hi,

The file is 425 blocks and the device has more than 6 GB space. The logicals are as follows.

show logi conv*

(LNM$SYSTEM_TABLE)

"CONVSHR_TV" = "CONVSHR"

show logi sort*

(LNM$SYSTEM_TABLE)

"SORTSHR_TV" = "SORTSHR"

Thanks in advance.

[Robert Gezelter]

Pradeep,

I would also recommend checking the setting of SYS$SCRATCH. CONVERT (which makes internal use of SORT) places the sort work files in SYS$SCRATCH.

- Bob Gezelter, http://www.rlgsc.com

[Jan van den Ende]

Pradeep,

Bob wrote:
>>>
I would also recommend checking the setting of SYS$SCRATCH.
<<<
"the setting" might be better worded as "the definition"

The simplest solution with the least side effects would be to enter into A.COM, in the line _JUST_ before $conv ...

$ DEFINE/USER SYS$SCRATCH XX$ABC_DATA:

(this will allways work, as long as the device that holds XX$ABC_DATA: has at least free space double the size of the file to be sorted. For really BIG files it may not provide maximum performance)

hth

Proost.

Have one on me.

jpe

[Robert Gezelter]

Pradeep,

As Jan correctly noted, it would be more precise to say "the value of the logical name SYS$SCRATCH".

The posting does not mention whether XX$ABC_DATA is the login device for this account. By default, the value of SYS$SCRATCH is set to the login device/directory.

As Jan noted, doing an ASSIGN/USER of a suitable scratch area to SYS$SCRATCH will likely resolve the problem.

- Bob Gezelter, http://www.rlgsc.com

[Joseph Huber_1]

> The file is 425 blocks

And with this little free space/quota on sys$scratch or the disk where Your home directory is located, You will most likely soon encounter similar problems with other applications as well.
Better cleanup or ask the system manager to increase Your quota !

[Hein van den Heuvel]

Most likely this is simply a failure to assign SYS$SCRATCH correctly.

This may be a problem with directory ownership and resource identifiers.

A temporary file, such as CONVWORK, is not associated with any directory. It has no directory backlink. The file system therefore has no way of associating the resource identifier on the directory with the file it creates.

What is the EXACT OpenVMS version?
Detail have changed in this area.

btw... Does the KEY specified in the FDL match the sort order of the input file? In that case you can use /NOSORT and not use CONVWORK at all!

Btw... similar issues in SORT may cause error message, yet convert succesfully.
See.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=950248

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting

[Pradeep Nair_1]

Thanks for all the support.