Usage Note 33578: Repairing corrupted metadata data sets
Metadata might become corrupted for a variety of reasons. Here are some tasks that might help avoid and indentify these corruptions:
- Avoid forcing termination of the metadata server SAS process by stopping the task. Abnormal termination of the metadata server might cause damage to the repository data sets.
- Monitor metadata server logs regularly for unusual errors or warnings. If some event occurs that causes corruption of metadata, you have a better chance of recovering quickly and with minimal loss of metadata if you identify the problem as soon as it occurs.
- Consider implementing workunit journaling. Workunit journaling causes the metadata server to post updates to the memory copy of repositories immediately, and to queue disk updates to a high–speed workunit journal file until the CPU is available to apply the updates to disk. If the metadata server fails before the update process has had a chance to apply all updates from the workunit journal buffer to repositories, the metadata server automatically recovers them from the workunit journal file when it is restarted. Refer to Chapter 13 in the SAS® 9.1.3 Intelligence Platform System Administration Guide for more information on workunit journaling
.
If you experience errors relating to corrupted metadata data sets, you can try to repair the data sets by performing the following steps:
- Stop your metadata server.
- Submit the following program in a SAS session:
/*Supply the path to the repository*/
libname repos 'Fully qualified path to metadata repository';
options DLDMGACTION=REPAIR;
proc datasets library=repos;
contents data=_all_;
run;
quit;
- Restart the metadata server and check the log for corruption errors.
If the data sets cannot be repaired using the program above, contact SAS Technical Support and provide copies of your metadata server log and the output from the PROC DATASETS step from the above program. In extreme circumstances, SAS Technical Support might request a copy of your metadata repositories.
Operating System and Release Information
| SAS System | SAS Metadata Server | z/OS | 9.1 TS1M3 SP4 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
| HP-UX IPF | 9.1 TS1M3 SP4 | |
| Linux | 9.1 TS1M3 SP4 | |
| Linux on Itanium | 9.1 TS1M3 SP4 | |
| Solaris for x64 | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2008-10-16 10:53:46 |
| Date Created: | 2008-10-09 15:43:45 |