ajsembdbrorg

Format

ajsembdbrorg
      -k {unld|reld}
      [-F scheduler-service-name]
      [-mh logical-host-name]
      [-agent]
      -d name-of-directory-where-unload-file-stored

ajsembdbrorg
      -k unld
      [-F scheduler-service-name]
      [-mh logical-host-name]
      [-agent]
      -d name-of-directory-where-unload-file-stored

ajsembdbrorg
      -k reld
      [-F scheduler-service-name]
      [-mh logical-host-name]
      [-agent]
      -d name-of-directory-where-unload-file-stored

To Page Top

Description

Obtains and restores the data in the embedded database.

You can execute this command only while the embedded database and all the scheduler services for which the applicable embedded database was created as the scheduler database are not running.

To Page Top

Execution privileges

In Windows: Administrators privileges

In UNIX: Superuser privileges

To Page Top

Storage directory

In Windows:

JP1/AJS3 - Manager-installation-folder\tools\

In UNIX:

/opt/jp1ajs2/tools/

To Page Top

Arguments

To Page Top

Notes

• This command is implemented by a script. If you specify an excessively long character string or an invalid character string or value for an option, an unexpected error might occur. You must use the number of characters allowed for a character string or a value in the option as specified in the DBMS and JP1/AJS3 specifications.

• Before you execute this command, stop all the scheduler services for which the applicable embedded database is created as the scheduler database. In addition, stop all the services that are accessing the embedded database, including the JP1/AJS3 service. If you execute this command without stopping services, you might need to wait for a long time.

• When you specify unld for the -k option, the directory you specify in the -d option must have the following free space:

  ajsembdbbuild option	Required free space
  -l (large-scale model)	About 6,700 MB
  -m (medium-scale model)	About 1,400 MB
  -s (small-scale model)	About 200 MB

  Furthermore, if the backup enhancement function is enabled, the following free disk space is required for the directory specified for the -d option.

  ajsembdbbuild option	Required free space
  -l (large-scale model)	About 7,200 MB
  -m (medium-scale model)	About 1,900 MB
  -s (small-scale model)	About 700 MB

  You can check the setting of the backup enhancement function by using the ajsembdbstatus command. For details about the ajsembdbstatus command, see ajsembdbstatus in 3. Commands Used for Normal Operations.

  Note that if the embedded database area is expanded by the ajsembdbaddarea command or the system log auto-increment function, the space incremented by the command or function is also required in addition to the space shown in the above table.

  Each time you execute this command, the above free space is required.

• Before you execute the command with the -k reld option (restoration) specified, make sure that maintenance of the embedded database area has been completed by using the ajsembdbreclaim command.

• If a failure such as a communication or disk failure occurs during execution of this command, the command might not respond. If the non-responding command cannot be killed manually, you can specify the embedded database system common definition pd_utl_exec_time to kill the command. For details about pd_utl_exec_time, see the system common definition in the 23.1.1 Examining the embedded-database operating environment and operating method in the JP1/Automatic Job Management System 3 Configuration Guide.

• Do not execute multiple ajsembdbrorg commands with the same scheduler service name set in the -F option for each command.

• Do not concurrently execute for a single embedded database multiple ajsembdbrorg commands in which the -agent option is specified.

• The setting of the backup enhancement function must be the same between the environment where data is to be restored by using the -k reld option and the environment where data was stored by using the -k unld option.

  For example, data that was stored by using the -k unld option in an environment where the backup enhancement function is enabled cannot be restored by using the -k reld option in an environment where the function is disabled.

To Page Top

Return values

To Page Top

Actions to be taken if an error occurs

If a command error occurs, take the indicated action in the following table.

To Page Top