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
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.