Search found 7201 matches

by admin
Wed Jul 03, 2002 6:52 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Can Users be limited to run certain jobs?
Replies: 3
Views: 447

NO. Projects are the lowest granularity for security, and apply so because of the intricacies involved in designing a job stream. You could mess with unix permissions on individual job executables, but that is messy and not readily apparent nor easy to manage. You should consider breaking your jobs ...
by admin
Wed Jul 03, 2002 6:51 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting director information
Replies: 8
Views: 827

Exporting director information

Does anyone know a way to export the job run information (the data in director as there are name of job, status, last time run, ...) to a text file. I would like to generate such an output so that I can process it a bit with a perl script to make reports of e.g. which jobs have gone wrong during the...
by admin
Wed Jul 03, 2002 6:50 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Exporting director information
Replies: 8
Views: 827

you can access all properties youve listed. in director, select HELP and search on DSJS.___ these are functions you can reference that will provide you all you seek. you can set up a control file to run late in the day and list all jobs and their status, running, aborted, etc.. start/end times, dura...
by admin
Wed Jul 03, 2002 6:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Problems in DS 5.2
Replies: 1
Views: 423

YOU CANNOT HAVE UMASK IN DSENV If you look at the start script S99ds.rc you will see a section at the top that scans the DSENV file and creates a temporary runtime version that only contains environment settings. This is documented in release 5.X+. Only environment variables (xyz=something) are allo...
by admin
Wed Jul 03, 2002 6:29 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Can Users be limited to run certain jobs?
Replies: 3
Views: 447

not sure via the admin tools etc... but you can create a "control" file in universe which holds jobs that the user have rights to run. when the job is involked, you scan the file for that user and their permmiussions and if they are allowed, let the job run otherwise, generate a log error and stop. ...
by admin
Wed Jul 03, 2002 6:18 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Problems in DS 5.2
Replies: 1
Views: 423

Problems in DS 5.2

Hi we have upgrade to Datastage 5.2, and we have some problems - we run our job, when the job abort, it still running and we cant stop it, in Datastage, only in Unix, with kill -9. Anybody have this problem ? - Why only the user who created the file can access to the file ? The output file it was cr...
by admin
Wed Jul 03, 2002 6:11 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Can Users be limited to run certain jobs?
Replies: 3
Views: 447

Can Users be limited to run certain jobs?

Hi All,

Is there a way to allow a user to schedule and run only a subset of jobs in a project (via the DataStage director)? We are using DataStage 5.1 on NT 4.

Thanks,

Scott
by admin
Wed Jul 03, 2002 5:57 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Problem trying to work on Metastage directory: "The Director
Replies: 0
Views: 432

Problem trying to work on Metastage directory: "The Director

Hi There, Im using Metastage and Im running in a problem. After Ive tryed to delete some object in an import category a problem occurs and Ive had to terminate the operation by task manager (that was in not responding status). Now I cant do nothing on my MetaStage Directory cause Metastage Explorer ...
by admin
Wed Jul 03, 2002 5:16 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Microsoft Outlook Test Message
Replies: 0
Views: 523

Microsoft Outlook Test Message

This is an e-mail message sent automatically by Microsoft Outlooks Account Manager while testing the settings for your POP3 account.
by admin
Wed Jul 03, 2002 5:46 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Handling concurrency
Replies: 1
Views: 409

Yes, currently, the files are being processed by moving them to a work area and then the processed area after they have been proceessed. There are thousands of files being processed. If some files are accidently opened from the work area then how does DS know that these are open? Appropriate message...
by admin
Wed Jul 03, 2002 5:41 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Handling concurrency
Replies: 1
Views: 399

Handling concurrency

This is a topic for an orphaned message.
by admin
Wed Jul 03, 2002 5:41 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Handling concurrency
Replies: 1
Views: 399

- How will you know if the file is in use ? - Can you move the file to a wip (work in Process) directory in a before Routine, and move it back in an after routine ? Or move it to specific directories when the File is available for the specific Job(s) ? - By flag appropriate warning messages, do you ...
by admin
Wed Jul 03, 2002 5:38 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Roiiback on errors/warnings
Replies: 0
Views: 522

Roiiback on errors/warnings

I am using ODBC stages to load data into Oracle. I want to rollback and prevent the load for all the output tables with appropriate error message, when one or more of the ODBC stages give warnings / errors and cannot load data. I know DBMSCODE, SQLSTATE can be used for the same, but not sure what co...
by admin
Wed Jul 03, 2002 5:27 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Handling concurrency
Replies: 1
Views: 409

Handling concurrency

Hi All! I have a requirement where if a file is already in use beforehand then I do not want DS job to be able to pick up this file. I want to flag appropriate warning messages in such a case. ________________________________________________________________________ Want to sell your car? advertise o...
by admin
Tue Jul 02, 2002 11:07 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Extract from BAAN
Replies: 1
Views: 405

Im fairly sure there is a plug-in stage type available for extracting from Baan. Contact Ascential. Raymond Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road, Southbank Vic 3006 Australia Telephone: +61 3 9626 6624 Facsimile: +61 3 9626 6622 Notes: Raymond ...