Config file issue with orchadmin

zulfi123786 · Post by **zulfi123786** » Sun Feb 28, 2010 2:44 am

I am trying to dump a dataset using orchadmin utility, the output is pasted below :

==> orchadmin dump -name /data/ds/hbus/dev/etl/datasets/copyAcctArrQc78.ds
##I TFCN 000001 04:56:21(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TFSC 000001 04:56:22(000) <main_program> APT configuration file: /tmp/aptoa27853769d0e243d
ARR_ID_ACCT:one ARR_ID_APP:two ACCT_SVCE_NUM:three MF_7_POS_FLD_1_A:four
##I TFOP 000059 04:56:22(000) <APT_RealFileExportOperator in APT_FileExportOperator,0> Export complete; 1 records exported successfully, 0 rejected.
##I TFSR 000010 04:56:23(000) <main_program> Step execution finished with status = OK.

The config file used as per above is APT configuration file: /tmp/aptoa27853769d0e243d

how to set the value to some other file? as i have used the below command but doesn't seem to work.

export APT_CONFIG_FILE=/opt/tools/ds/Ascential/DataStage/Configurations/hbus-1Node.apt

ArndW · Post by **ArndW** » Sun Feb 28, 2010 5:10 am

That config file is just a temporary one, not the one stored in the dataset. Use "orchadmin describe {dataset}" or "orchadmin ll {dataset} to get the configuration file information.

zulfi123786 · Post by **zulfi123786** » Sun Feb 28, 2010 5:59 am

orchadmin describe also shows the same config file

==> orchadmin describe /data/ds/hbus/dev/etl/datasets/copyAcctArrQc78.ds
##I TFCN 000001 05:57:43(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TFSC 000001 05:57:43(001) <main_program> APT configuration file: /tmp/aptoa1892592db6b77a0
Name: /data/ds/hbus/dev/etl/datasets/copyAcctArrQc78.ds
Version: ORCHESTRATE V7.5.1 DM Block Format 6.
Time of Creation: 02/27/2010 04:32:10
Number of Partitions: 1
Number of Segments: 1
Valid Segments: 1
Preserve Partitioning: false

##I TFOP 000059 05:57:44(000) <APT_RealFileExportOperator in APT_FileExportOperator,0> Export complete; 8 records exported successfully, 0 rejected.
##I TFSR 000010 05:57:44(000) <main_program> Step execution finished with status = OK.

ersunnys · Post by **ersunnys** » Sun Feb 28, 2010 6:10 am

Hey,

Dataset in Datastage keeps the cofig file information which is used when we write the Dataset.

You do not use external APT_CONFIG file while reading a Dataset, Datastage use the config file information which got stored in it while writing, so at time of reading it creates a temporary config file and use it.

You can not set the config file while reading a Dataset, if you want to change the node configuration then need to rewrite the Dataset it required config file.

Sunny

ArndW · Post by **ArndW** » Sun Feb 28, 2010 9:04 am

Sunny is mostly correct but I do need to correct one fallacy. If a dataset is written with a 2-node configuration there is nothing that prevents a 4-node configuration job to read it; DataStage will automatically and implicitly repartition the dataset.

ray.wurlod · Post by **ray.wurlod** » Sun Feb 28, 2010 1:12 pm

Review all the options of orchadmin, particularly -x option.