Our system took a hard dive yesterday - but we're impressed with DS resilience!! However, it came to our attention today that in one - and only one - of our many projects our developers are unable to access any Table Definitions.
When an attempt is made to import table definitions the following error message is encountered:
"Table Definitions: Browse List is Empty"
With this knowledge we went through the appropriate steps and then issued the LIST DS_METADATA command for that project - and got this response:
File '/proj/dsadm/Ascential/DataStage/Projects/dovmmvs/DS_METADATA/DATA.30':
Computed blink of 0x800 does not match expected blink of 0x0!
Detected within group starting at address 0x117000!
we then ran the CLEAR.FILE DS_METADATA command and received this response:
File "DS_METADATA" has been cleared.
Followed by the LIST DS_METADATA command again which yielded this repsonse:
0 records listed.
From there we then imported our table definitions from our last backup into the problematic project. Now when we do the LIST DS_METADATA we get an extensive list. Likewise, if I go into Manager and request to do an export of the table definitions (by Individual Component) I again get a very long list of table defs to choose from.
But here's the problem - if I attempt to import a table def from designer I still get the message: "Table Definitions: Browse List is Empty" and my "Table Definitions" in my repository view in designer also appears empty - I see nothing in it.
Ideas?? Suggestions???
Help!!!
Thanks
Jennifer
System Crashed - can't restore table defs
Moderators: chulett, rschirm, roy
Do a search on DS.TOOLS. There may be an index which got corrupted. You can rebuild all indexes with one of the programs in DS.TOOLS.
If it does not fix these indexes then you might be able to manually fix them by going to the good project and
LIST.INDEX DS_METADATA ALL
You would need to
DELETE.INDEX DS_METADATA index1
DELETE.INDEX DS_METADATA index2
CREATE.INDEX DS_METADATA index1
CREATE.INDEX DS_METADATA index2
BUILD.INDEX DS_METADATA all
If it does not fix these indexes then you might be able to manually fix them by going to the good project and
LIST.INDEX DS_METADATA ALL
You would need to
DELETE.INDEX DS_METADATA index1
DELETE.INDEX DS_METADATA index2
CREATE.INDEX DS_METADATA index1
CREATE.INDEX DS_METADATA index2
BUILD.INDEX DS_METADATA all
Mamu Kim
Hello, I am a co-worker with Jennifer.
What is the syntax for a "search on DS.TOOLS"?
The LIST.INDEX DS_METADATA ALL" returns information on four indexes:
ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY
I am guessing that the CATEGORY one is the one that needs to be rebuilt.
Is there a way of rebuilding a specific index rather then the "DS.REINDEX DS_METADATA" or "DS.REINDEX ALL" commands?
The "DS.REINDEX DS_METADATA" seems to compile all but the CATEGORY one.
Thanks
Warren.
What is the syntax for a "search on DS.TOOLS"?
The LIST.INDEX DS_METADATA ALL" returns information on four indexes:
ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY
I am guessing that the CATEGORY one is the one that needs to be rebuilt.
Is there a way of rebuilding a specific index rather then the "DS.REINDEX DS_METADATA" or "DS.REINDEX ALL" commands?
The "DS.REINDEX DS_METADATA" seems to compile all but the CATEGORY one.
Thanks
Warren.
The list is
ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY
So
DS.TOOLS should be able to rebuild all of these. Make sure nobody is in DataStage when you do this. You have to have exclusive access to a file to build an index.
ACCESSTYPE
ACCESSCAT
PLATFORMTYPE
CATEGORY
So
Code: Select all
DELETE.INDEX DS_METADATA ACCESSTYPE
DELETE.INDEX DS_METADATA ACCESSCAT
DELETE.INDEX DS_METADATA PLATFORMTYPE
DELETE.INDEX DS_METADATA CATEGORY
CREATE.INDEX DS_METADATA ACCESSTYPE
CREATE.INDEX DS_METADATA ACCESSCAT
CREATE.INDEX DS_METADATA PLATFORMTYPE
CREATE.INDEX DS_METADATA CATEGORY
BUILD.INDEX DS_METADATA ALL
Mamu Kim