Rdb Temporary Files

Question

What temporary files does Rdb open and what logicals do they use? I am getting the following error message from Rdb:

OPEN BIB_CURSOR Failed %RDB-F-SYS_REQUEST, error from system services request -RMS-F-DEV, error in device name or inappropriate device type for operation

Answer

Are you attempting to run the job as a detached process? Rdb creates a number of temporary files. These are placed in a variety of places based on process logicals:

	Run Unit Journal (ruj) defaults to sys$login_device:[rdm$ruj]
	Sort work and other temporary files default sys$scratch which is defined to be the sys$login directory by default.

In a process that is created by running the program/detach, the process logicals sys$login and sys$login_device are not defined, which would result in an error like the one you have described. You can work around this by either explicitly defining the logicals for your detached process or creating a command procedure and running sys$system:loginout as the detached image.

Keith Hare
JCC Consulting, Inc.

Copyright © 1995, JCC Consulting, Inc. All rights reserved. Proprietary to JCC Consulting, Inc. Information retrieved from this server may be used for internal purposes only and may not be posted elsewhere without written permission. Information accessible from this server is provided on an as-is basis. JCC exercises no editorial control over the information provided, except that written by JCC dealing with JCC services and products. JCC and the JCC logo are trademarks of JCC Consulting, Inc. The look of the signs or header panels is a trademark of JCC Consulting, Inc. Oracle is a registered trademark of Oracle Corporation. ORACLE Rdb is a trademarks of Oracle Corporation.

JCC, JCC., JCC.com, jcc.com, the JCC logo, utilities, utilities., utilities.com, buyandsell, buyandsell., buyandsell.com, buyway, buyway., JCCLogLoader, JCCLoader, JCCLogMinerLoader, LogLoader, LogMinerLoader and buyway.com, are marks of JCC Consulting, Inc.

Oracle is a registered trademark of Oracle Corporation. ORACLE Rdb and LogMiner are trademarks of Oracle Corporation. Windows NT is a trademark of Microsoft Corporation. VMS is a trademark of Compaq Corporation.