Error:Project DSS_P is not set up for Datastage use

[holymac]

Dear All,

Few days ago, one of the project work folder reaced 99% space usage and hanged.We managed to identify the issue and increased the space. The ETL batch managed to resume as normal but another problem arised.

Whenever I tried logging in using the dsadm id to either Manager/Director/Designer or Administrator it is giving this error:

"Project DSS_P is not set for Datastage use: Cannot open file DSR_JOBS".

Even through DS Administrator i cant see the project at all.

Kindly assist on what could be the issue and what could be done to rectify this issue?

Thank you in advance.

[ArndW]

holymac,

most likely you disk didn't reach 99% but hit 100% while DataStage was working and you have a broken hashed file in that project; perhaps even the DS_JOBS (did you cut-and-paste the error message or type it in?).

You should first do a backup of your project (in addition to your normal system backup). Then you will need to enter your project from TCL; if you have not done this before then:

1. cd to your DataStage home directory (you can do a "cd `cat /.dshome`)
2. set up your environment (". ./dsenv")
3. enter TCL in the master account ("/bin/dssh")
You will now get a ">" prompt and your keyboard is in UPPERCASE.
4. do a "LOGTO DSS_P" to go to your project.
5. do a "UVFIXFILE DS_JOBS" to see if the file is corrupt.
6. enter "QUIT" to exit back to your unix shell.

[ray.wurlod]

3. enter TCL in the master account ("bin/dssh") (no leading "/" in the pathname)