Unsolved
This post is more than 5 years old
1 Rookie
•
20 Posts
0
2196
Infoscape DX NAS Database Dump Clip List
Hi,
I would like to generate a clip list from Infoscape – DX NAS, version 3.0, build 1.28.
Firstly, does DX-NAS use the PostGre SQL database? if so then I know that you can dump the database which includes all clip addresses etc.
If not then what database does DX NAS (Infoscape) use?
Does anyone know on how I can generate a clip list from the DX-NAS (Infoscape) database?
I want to compare this clip list with what is on the Centera and therefore do not want to generate a clip list from DX by querying the Centera, but export the clip addresses that DX NAS thinks it knows about from its own internal database.
If anyone knows of how to do this your help woudl be much appreciated.
Thanks in advance.
Dave
ptinius
15 Posts
0
October 17th, 2012 06:00
DX NAS uses Sybase SQL anywhere as its database.
The C-CLIP list stored by DX NAS should only be valid, i.e. none orphan secondary files. Orphaned files are file that exist within secondary storage but have no stub ( source file reference ).
There are not any utilities available to access this information directly, so you will have to use your favorite SQL query tool.
Database connection user: DBA
Database connection password: SQL
Then use the following simple SQL queries.
SELECT dba.secondary_file.secondary_name FROM dba.secondary_file;
SELECT dba.secondary_data_file.secondary_file_id FROM dba. secondary_data_file;
The reason for the two queries is that at some point the secondary file data structure was changed.
Paul