DSXchange

ArndW wrote:Does "/home/apps/ds/xxxxxxxxxx/tmp/APTcs34816348276acd5" exist?

No, it is not.

ArndW wrote: Does the path ""/home/apps/ds/xxxxxxxxxx/tmp" exist?

Yes

Hi, I am trying to run a parallel job and getting the following error message: ##W TFAR 000000 22:49:37(000) <main_program> File archive: Trouble creating file "/home/apps/ds/xxxxxxxxxx/tmp/APTcs34816348276acd5" >##F TFPX 000002 22:49:37(001) <main_program> Fatal Error: Null archive. Let m...

Thanks for the reply

ray.wurlod wrote:Which ISO standard specifies that format?

Not sure. My guess is that this is an extended format for ISO 8601.

ray.wurlod wrote:What is "0Z"?

'Z' is the zone designator for the zero UTC (Coordinated Universal Time) offset.

Hi,

Is there any function to convert the current DateTimestamp into the following ISO date format: 2009-07-29T11:20:32.0Z

Thanks

Hi, Scenario: Sequencer which calls a parallel job has param problem. In the sequencer, I have an execution_comand stage where I am using cat <file_name> to read a date value stored in the file. This stage is connected to a similar stage where I read another date from another file. Both These values...

Hi,

Heard that dropping the index will give better performance in some jobs. Can anybody explain how to do it and how it happens?

Regards
Subramanya

The SQL issue has been covered in this forum; in addition it is very important for you to do a DS.TOOLS and reindex; the secondary indices are linked to by absolute pathnames, so doing an OS level move of the files and indices will cause corruption that requires index rebuild. If I use DS.TOOLS or ...

Hi, The server in which the project was residing has crashed. So I created a project with the same name on a different machine and copied the prevoius project folder to the current installation project folder. Now if I try to login into DS Manager, the following error message is coming "DSR.ADM...

Arnd,
Thanx for the sugestion.
For ODBC stage with Isolation Level as Auto-commit, it works fine. But in all the jobs I have used Sybase OC stage.

Regds
Subramanya

Hi Criag,
I am using Sybase OC stage(Sybase ASE database). For Transaction Isolation we have 3 options: "Read uncommited, Read commited and Serializable" . Whatever option I choose, the same warning is coming..

Thanx for the reply

Subra

Hi, In the server job, I am using a Sybase table (which is read only ) as the source table. While running the job I am getting the following warning: "SRC_CMC_SBSB_SUBSC: Sybase Server warning 3906 (severity 16): Attempt to BEGIN TRANSACTION in database 'fidelis_311' failed because database is ...

Hi, The routine is getting the time when the job last run. What i wanted was if the routine executed without any error, then the job should execute with the parameter retured from that routine. But now it looks that I shud give "Unconditional" in the Expression Type . Is there any method t...

Hi, In a Sequencer job, I am executing a routine in the routine activity stage and later a job. If Triggers -- Expression Type is specified as "OK - (Conditional) in the routine activity stage then my job is not triggerred. If you give " Unconditional" or "Failed-(Conditional)&qu...

Not Much calculations. . Its a staging job where i am pooling fields from diffrrent tables.

Subs

Hi,
I have 20 lookups which can be done in a single transformer stage. Whether dividing them across 4 transformers(say 5 lookups each) will increase the performance ?

Thnx
Subs