Listing backups and restores

Deployment options: IBM Netezza Appliance

Learn how to list recent backups and restores.

Procedure

  1. Make sure that NZ_USER, NZ_PASSWORD and NZ_HOST are set correctly.
  2. Run: 
    "https://${NZ_HOST}/v1/backups -H  "accept: application/json" -d "{
    \"user_name\":\"${NZ_USER}\", \"token\":\"${NZ_PASSWORD}\"}"
    Output:
    { "batch_list" : [
    {
      "batchid": "20200505055358",
      "batchstatus": "COMPLETED",
      "op": "restore",
      "batchtype": "ADHOC",
      "num_databases": 1,
      "databases": [
        {
          "type": "INCR:UPTO",
          "status": "COMPLETED",
          "database": "TPCH30",
          "increment": 1,
          "backupset": "20200505043208",
          "user": "ADMIN",
          "pid": 134342,
          "label": {},
          "numbytes": 13742849999,
          "duration": 214,
          "error": []
        },
        ... 
      ]
    The response format details:
    listBackupResponse{
	batch_list	[{
		batchid	string
		example: 20200729203150
		batchid

		batchstatus	string
		example: ACTIVE|COMPLETED|FAILED|S3DELETED
		batch status

		op	string
		example: backup
		operation type, backup/restore

		batchtype	string
		example: SCHEDULED
		batchid

		num_databases	integer
		example: 1
		number of databases

		databases	[{
			type	string
			example: FULL

			status	string
			example: COMPLETED

			database	string
			example: DB1
			the specific database instance

			increment	integer
			example: 1

			backupset	string
			example: 20200729203149

			user	string
			example: ADMIN

			pid	integer
			example: 3917

			label	{...}

			duration	integer
			example: 0

			numbytes	integer
			example: 0

			error	[{
				timestamp	string
				example: 20200729203150
				error_message	string
				example: this is an error
			}]
			 
		}]
		 
	}]
	status	string
	example: SUCCESSFUL
	message	string
	example: Operation Done
}