Fetch value for APT_CONFIG_FILE value in Unix environment?

videsh77 · Post by **videsh77** » Tue Feb 06, 2007 6:03 am

In AIX environment, is there any way to find out what value has been set for APT_CONFIG_FILE for the datastage environment?

The reason I am asking this, I dont have an access to DataStage administrator. So I want to know, if environment is using configuration file other than "default.apt"?

DSguru2B · Post by **DSguru2B** » Tue Feb 06, 2007 8:17 am

You dont need access to the the administrator. You can just go to your log, the second entry will have all the environment variables. You can see the value of APT_CONFIG_FILE.
You can also go to your Project home directory and do

Code: Select all

cat DSParams | grep "APT_CONFIG_FILE"

ArndW · Post by **ArndW** » Tue Feb 06, 2007 8:23 am

The DSParams lookup will show the project level default settings, but jobs can override this at runtime so that value may be incorrect. The best way to check is to look at the second log entry as DSGuru2B has already stated.

DSguru2B · Post by **DSguru2B** » Tue Feb 06, 2007 8:25 am

ArndW wrote:The DSParams lookup will show the project level default settings, but jobs can override this at runtime so that value may be incorrect.

O yea thats correct. Did'nt pay attention to that. Thanks for the clarification ArndW.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 06, 2007 3:57 pm

Why not just

Code: Select all

 grep APT_CONFIG_FILE DSParams

DSguru2B · Post by **DSguru2B** » Tue Feb 06, 2007 4:01 pm

Because of the fact that its value might be overwritten during run time as ArndW suggested. Or are you referring to the correct use of grep syntax?

videsh77 · Post by **videsh77** » Mon Feb 12, 2007 6:19 am

Hi DSGuru

How will go to the project home?

Since .dshome represenet DS Engine home directory? Where will you look for?

DSguru2B · Post by **DSguru2B** » Mon Feb 12, 2007 8:05 am

Once you are in the home directory, go back a directory (cd ..). You will see a folder called "Projects". Go into that folder, you will see all the project names that you have setup. Go inside your project. You will find the DSParams file there.

ArndW · Post by **ArndW** » Mon Feb 12, 2007 8:09 am

Your project will be in the directory DSGuru2B mentioned if you used the default installation paths; but note that project directories can (and are) put anywhere on the machine.
If you login using the Administrator it will show you the path to a project and you can use that to find the project's DSParams file.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 12, 2007 2:57 pm

Actually, the value $APT_CONFIG_FILE is meaningless in the UNIX environment.

videsh77 · Post by **videsh77** » Tue Feb 13, 2007 5:57 am

Its great I could find DSParams file, which is part of projects directory.

But it was not at the default location. I had to search from the root to go to the projects folder.

After installation like .dshome, is there any file which has path information stored within to point to the different project locations, especially for non-admin users?

Also for admin users, as ArndW written, which location they will get to see path/pointer to different projects?

ArndW · Post by **ArndW** » Tue Feb 13, 2007 7:58 am

Videsh - You misinterpreted what I said.

After installation like .dshome

? Not sure what you mean there, but yes, there are files and tables which point to the project directories.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 13, 2007 2:29 pm

Using the Administrator client, any user can determine the location of a project. This is reported in the status bar when a project is selected.

On the server, location of a project is recorded in the hashed file UV.ACCOUNT and in the system table UV_SCHEMA. You can access both of these from the DataStage engine directory ($DSHOME) using appropriate DataStage/SQL queries.