Page 1 of 1
Code usage from Server jobs environment to Parallel jobs ???
Posted: Thu Nov 17, 2011 12:01 pm
by Developer9
Hi,
Current Env:parallel edition (7.5) I am doing analysis on "recently moved code "from server edition.(7.5)
1.How to parameter jobs without code modifications for file creation everytime??
2.what things to understand from environment prospective (sources ,db2 connections/configurations,environment variables)??
please share your ideas
Posted: Thu Nov 17, 2011 2:43 pm
by ray.wurlod
1. Not possible in version 7.
2. It's totally different. A different mindset is required. Read Parallel Job Developer's Guide as well as the connectivity guide for any database to which you want to connect.
@ray..thanks
Posted: Thu Nov 17, 2011 5:13 pm
by Developer9
More collaberatively :
We have recently migrated the DataStage code(Scripts DB2UNLOAD.sh ,csvs,ini's etc..)from different dev (A) .Now want to check and see if is feasible to run in current Dev (B) with the changes? Update the jobs (things to consider )???
details:The Environment B..is Parallel extender(Parallel jobs ) and vesrion 7.5.2 andDB2, UNIX and The Env A ..is server jobs and ve 7.5.2 and DB2,UNIX ,
Thank you
Posted: Fri Nov 18, 2011 8:55 am
by chulett
Please clarify what you mean by "DataStage code". Tt seems you are
not including the actual
jobs in that statement but rather all of the ancillary supporting objects like scripts, source files, etc? Is that true?
Re: Code usage from Server jobs environment to Parallel jobs
Posted: Fri Nov 18, 2011 8:57 am
by chulett
Developer9 wrote:1.How to parameter jobs without code modifications for file creation everytime??
Ray may have undestood this question but I have no clue what you are asking. Are you asking if you can add parameters to a job without modifying
the job itself? Again wondering what exactly "code" means in this context.
Re: Code usage from Server jobs environment to Parallel jobs
Posted: Fri Nov 18, 2011 2:30 pm
by Developer9
chulett wrote:Developer9 wrote:1.How to parameter jobs without code modifications for file creation everytime??
@chulett
I Have the following scenario needs to be implemented:
Environment:DStage7.5.2(Parallel edition),AIX 5.3,DB2V8.
step1:Unload tables :-We have DB2 Tables:1)base table ex:customer 2)monthly tables (25 ):customer_M1 ,customer_M2...customer_M25 (Loaded at every month)
script used:Unload.sh (unix batch script)..as
#command array#CUSTOMER.sh ...takes table name as parameter ..AND generates file format (customer.exe)
approach:How to run multiple instances of the job to generate the files M1 to M25 ..so that customerM1.exe,customerM2.exe...customerM25.exe ..and This job should be parametrized such that it takes the table name as parameter ???
How we do implement in Batch frame work ??
Thanks ...