Code usage from Server jobs environment to Parallel jobs ???

[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

[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.

[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

[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?

[chulett]

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.

[Developer9]

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 ...