ListStatus

The ListStatus action lists the database and file encryption states.

The syntax of the ListStatus action is as follows.

jdbcrypt path=database-path
         ini=initialization-file-name
         action=ListStatus [ListPartitions=true]

The following is an example of the ListStatus action.

jdbcrypt path=d:\dbcrypt ini=d:\salesdb\jade.ini action=ListStatus

The database and file encryption states are output to the console (that is, to stdout). For details about displaying and redirecting JADE batch utility output, see the DisplayApplicationMessages, LogServer, and UseLogServer parameters under "JADE Log Section [JadeLog]", in the JADE Initialization File Reference.

The following is an example of the output when database encryption is enabled but there are no encrypted files.

JADE Database Encryption Utility Version 7.1.0.0 Copyright (c) Jade Software Corporation Limited 2014

#Database and File encryption status
Opening database directly ...
Database UUID: 48cf13de-b6fd-df11-87e2-2e5920524157
Last update was #1 at 2014/01/11 17:10:55.578
Encryption UUID: 81bca195-b145-01cb-1037-000056faf402
Encryption Timestamp: 2014/01/11 04:10:40.767(UTC)
MasterKey is valid

FILE NAME
 tdb _TDB                 Plaintext
  11 _environ             Plaintext
  31 _userscm             Plaintext CurrentCI=none PendingCI=none
  32 _userxrf             Plaintext CurrentCI=none PendingCI=none
  33 _usergui             Plaintext CurrentCI=none PendingCI=none
  34 _userint             Plaintext CurrentCI=none PendingCI=none
  35 _userdev             Plaintext CurrentCI=none PendingCI=none
  40 _rootdef             Plaintext CurrentCI=none PendingCI=none
  51 dbcrypttesting002    Plaintext CurrentCI=none PendingCI=none
  52 dbcrypttesting003    Plaintext CurrentCI=none PendingCI=none
  53 par493               Plaintext CurrentCI=none PendingCI=none
  88 dbcrypttesting       Plaintext CurrentCI=none PendingCI=none
 190 dbcrypttesting001    Plaintext CurrentCI=none PendingCI=none

The following is an example of the output when database encryption is enabled and all user data map files are encrypted.

JADE Database Encryption Utility Version 7.1.0.0 Copyright (c) Jade Software Corporation Limited 2014

#Database and File encryption status
Opening database directly ...
Database UUID: 48cf13de-b6fd-df11-87e2-2e5920524157
Last update was #1 at 2014/01/11 17:10:55.578
Encryption UUID: 81bca195-b145-01cb-1037-000056faf402
Encryption Timestamp: 2014/01/11 04:10:40.767(UTC)
MasterKey is valid

FILE NAME
 tdb _TDB                 Plaintext
  11 _environ             Plaintext
  31 _userscm             Plaintext CurrentCI=none PendingCI=none
  32 _userxrf             Plaintext CurrentCI=none PendingCI=none
  33 _usergui             Plaintext CurrentCI=none PendingCI=none
  34 _userint             Plaintext CurrentCI=none PendingCI=none
  35 _userdev             Plaintext CurrentCI=none PendingCI=none
  40 _rootdef             Encrypted CurrentCI=present PendingCI=none
  51 dbcrypttesting002    Encrypted CurrentCI=present PendingCI=none
  52 dbcrypttesting003    Encrypted CurrentCI=present PendingCI=none
  53 par493               Encrypted CurrentCI=present PendingCI=none
  88 dbcrypttesting       Encrypted CurrentCI=present PendingCI=none
 190 dbcrypttesting001    Encrypted CurrentCI=present PendingCI=none

Run the ListStatus action regularly, to verify the encrypted status of all files in your database.