The dbfhdeploy Command Line Utility

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use the dbfhdeploy command line utility to deploy files to your datastore databases.

Syntax:

dbfhdeploy [Options][Category] ActionParameters 
Options
Refer to the running of the command as a whole:
  • -opt - turns on file I/O optimization when deploying files. This option is on by default.
  • -noopt - turns off file I/O optimization when deploying files.
  • -nobanner - display minimal output.
  • -urlhelp - display information about the URL syntax.
  • -verbose - displays additional information, such as the database configuration file and script folder locations in effect, and the deployment time for the current operation.
Category
Defines the item to be acted upon. Valid values are:
data
The item to be acted on is a data file.
For an add, delete, or extract action, the URL must be of the form: sql://host[/instance]/datastore/filename[?folder=/path]

For a create or list operation, the URL must be of the form: sql://host[/instance]/datastore[?folder=/path]

ActionParameters
Action to perform and the data store to perform it on. Valid values are:
list URL
Lists data files that are located in the specified URL.
For example, the following command lists all the data files and sub-folders stored in the VSAM folder of the ESDEMO datastore:
dbfhdeploy data list sql://svr-mydb/ESDEMO?folder=/VSAM
create URL
Create a datastore in the specified URL.
For example, the following command creates the NEWDEMO datastore in the svr-mydb instance:
dbfhdeploy data create sql://svr-mydb/NEWDEMO
add path URL;attribs
Add data file specified in path to the datastore specified in URL.
Some file types require additional attributes, which can be:
type=seq|lseq
The type of file (other than a VSAM file) that is being added.
reclen=min,max
The minimum and maximum length of each record within the file.
recterm=windows|linux|unix
The type of record terminator used in the file. This is used primarily for RRDS files, and is only required for files that have been created on a different platform to the one on which it is currently being deployed.
For example, the following command adds the sequential file file.dat to the USRA folder, in the NEWDEMO datastore in svr-mydb, where it is referred to as mydat and has a (minimum and maximum) record length of 80:
dbfhdeploy data add file.dat sql://svr-mydb/NEWDEMO/mydat?folder=/USRA;type=seq;reclen=80,80
delete URL
Delete data files from datastore specified in URL.
For example, the following command deletes the mydat data file stored in the USRA folder, in the NEWDEMO datastore:
dbfhdeploy delete sql://svr-mydb/NEWDEMO/mydat?folder=/USRA
You can also delete multiple files/folders using one of the following:
  • The following command delete all files and sub-folders under the MyTests folder:
    dbfhdeploy delete sql://svr-mydb:50000/VSAM?type=folder;folder=/MyTests
  • The following command deletes all files and folders within the VSAM data store:
    dbfhdeploy delete sql://localhost:50000/VSAM?type=folder;folder=/
  • The following command deletes all files within the MyTests folder that start with 'a' or 'A':
    dbfhdeploy delete sql://localhost:50000/VSAM/a*?folder=/MyTests
Tip: Specifying the -verbose option with any of these commands displays the files and folders that are deleted.
extract URL path
Extracts a copy of the data file specified in URL to the path specified by path.
For example, the following command extracts a copy of mydat from the USRA folder of the NEWDEMO datastore, and saves it as my-extract.dat:
dbfhdeploy data extract sql://svr-mydb/NEWDEMO/mydat?folder=/USRA my-extract.dat
upgrade URL
Note: Only use this option when instructed to by a Micro Focus SupportLine representative.
Upgrades the stored procedures associated with the data file specified in URL.
For example, the following command upgrades any stored procedures associated with the mydat2 data file stored in the USRB folder of the NEWDEMO datastore:
dbfhdeploy upgrade sql://svr-mydb/NEWDEMO/mydat2?folder=/USRB