Question & Answer
Question
What is the difference between the 'md' & 'data' folders for a Netezza Backup?
Cause
Explanation of the 'md' & 'data' folders
Answer
The 'md' directory stores metadata information about individual backup and 'data' directory stores actual data for each table/object.
Check the contents.txt and schema.xml files in 'md' dir, those will have the reference of all objects with object id, that refer to files
in 'data' dir,
-- see example below
If any file in 'data' dir missing that will catch during the nzrestore process. As I eluded to earlier, currently we don't have any way to
very backup data.
“md”; metadata
schema.xml .. the definitions of the objects
The metadata starts with a “<TABLE“ tag, and ends with a
“</TABLE> “ tag. Following is an example of metadata of a table
named “MY_PROBLEM_TABLE”. In this
file you will see the objectid for tables.
<TABLE ver="2" name="MY_PROBLEM_TABLE" schema="ADMIN" owner="ADMIN"
oidhi="0" oid="1336650" ...
<COLUMN name="COL1" ...
<COLUMN name="COL2" ...
<DISTRIBUTION seq="1" attnum="1"/>
</TABLE>
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg22005086