☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-04-2023 09:56 AM
(791 views)
Hi,
We have a huge metadata respository SAS 9.4 (40 GB) and we have tried to use analyze/repair but no reduction in size. Could you share some code which makes is possible to see the size of the objects in out metadata repository.
Thanks in advance.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are you running a clustered Metadata server? If so you may want to start it in noCluster mode an run a reorganization backup to physically remove any deleted objects.
About the Reorganize Repositories Backup Option
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...
The size of a Metadata object isn't stored as an attribute of that object in Metadata, I'm not aware of a way to output the size of objects in the repository. Often, this is a function of the number of objects rather than an individual object's size.
About the Reorganize Repositories Backup Option
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...
The size of a Metadata object isn't stored as an attribute of that object in Metadata, I'm not aware of a way to output the size of objects in the repository. Often, this is a function of the number of objects rather than an individual object's size.
--
Greg Wootton | Principal Systems Technical Support Engineer
Greg Wootton | Principal Systems Technical Support Engineer
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are you running a clustered Metadata server? If so you may want to start it in noCluster mode an run a reorganization backup to physically remove any deleted objects.
About the Reorganize Repositories Backup Option
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...
The size of a Metadata object isn't stored as an attribute of that object in Metadata, I'm not aware of a way to output the size of objects in the repository. Often, this is a function of the number of objects rather than an individual object's size.
About the Reorganize Repositories Backup Option
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...
The size of a Metadata object isn't stored as an attribute of that object in Metadata, I'm not aware of a way to output the size of objects in the repository. Often, this is a function of the number of objects rather than an individual object's size.
--
Greg Wootton | Principal Systems Technical Support Engineer
Greg Wootton | Principal Systems Technical Support Engineer