Extracting data with Read only access to Datacom Database files

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

If a programmer has Read-only privileges to a Datacom database file (index or data area), they have historically not been able to open that database to perform read functions like EXTRACT or BACKUP. 

Now, as more functions are running under the authority of the MUF, a user can run these read functions under the MUF's control, regardless of the user's dataset access rights. 

Environment

Release : 15.0, 15.1

Component : Datacom/DB

Resolution

In order to use the access rights of the MUF user, it is necessary to code MULTUSE=YES on the DBUTLTY function. Without this, the DBUTLTY function runs under the security privileges of the user submitting the DBUTLTY job.

For example, here is a DBUTLTY step to EXTRACT data from a table, showing the MUTLUSE parameter:

//STEP1    EXEC P@DBUTL   <-- DBUTLTY proc

//EXABC123 DD  DSN=MY.EXTRACT.FOR.ABC123,DISP=(,CATLG,DELETE),

//             UNIT=SYSDA,SPACE=(CYL,(500,150),RLSE)

//SYSIN    DD  *             

  COMM    DBID=123,OPTION=STATS

  REPORT  DBID=123,AREA=CXX,TYPE=A    <== SHOW RECORD COUNTS

  EXTRACT DBID=123,AREA=ABC,TABLE=ABC,DDNAME=EXDEB175,

          SEQ=PHYSICAL,MULTUSE=YES           

/*

 

Note that running within the MUF address means that you will have the buffers and other features used in the MUF, and not those found within the DBUTLTY address.

Additional Information

For further information on which functions can run inside the MUF or in Single User mode, please see the version 15.1 Utility Function Summary.

For more details on the various DBUTLTY functions, please see the version 15.1 DBUTLTY Reference.