Hi
"Enable partition reads" will work with partitioned databases in DB2 - if you have a single partition database you will not see a performance effect
regards
MT
Search found 194 matches
- Wed Aug 23, 2017 1:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 connector - doubling records
- Replies: 3
- Views: 4281
- Sat Nov 07, 2015 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to avoid backup pending tablespaces
- Replies: 3
- Views: 3910
Re: How to avoid backup pending tablespaces
Hi More detailed information will get you better answers! I guess - and I am very sure chulett as well - that you are talking about DB2. Load in DB2 has several options to ensure consistency in the database while it does not use SQL and standard logging to add the data. You have giut a so called Cop...
- Tue Nov 03, 2015 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector - Issue in updating the table
- Replies: 1
- Views: 3347
Re: DB2 Connector - Issue in updating the table
Hi sridinesh2009, first I wonder that your statement still works as the DB2 Connector usually wants ORCHESTRATE.column-name instead of "?". I have recommended to an create index for these situations a lot of times and I have no idea why this should not be possible - maybe not for you perso...
- Fri Sep 25, 2015 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Bulk stage - NLS settings
- Replies: 7
- Views: 4038
- Thu Sep 24, 2015 11:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Bulk stage - NLS settings
- Replies: 7
- Views: 4038
Hi ok two more things you could do: - You said that you viewed the file - did you use DataStage View...? If so I stongly recommend to do it natively on the OS because DataStage View will already interpret the data. - I would also strongly recommend DB2 Connector stage if you work with DB2 Your datab...
- Thu Sep 24, 2015 1:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Bulk stage - NLS settings
- Replies: 7
- Views: 4038
Re: DB2 Bulk stage - NLS settings
Hi Dinesh, it is always a little hard to say where the stuff gets converted or lost - so it is not enough to look at the db2 stage where you load it. default NLS Map Name is UTF-8 in the target db2 bulk stage. Having UTF-8 for the database and as NLS in the DataStage job you could use the DB2CODEPAG...
- Mon Apr 13, 2015 12:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
- Replies: 8
- Views: 5813
Hi Abhishek, why are you not using the DB2 Connector - relly recommended when using DS8 as described! The db2nodes.cfg is only available in partitioned DB2 databases - so yes it might be a good idea to ask your Db2 admin. But again if you use the Db2 Connector you do not have to worry about the dbno...
- Sat Aug 09, 2014 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage DB2 Bulk load vs DB2 load utility
- Replies: 2
- Views: 4145
Re: Datastage DB2 Bulk load vs DB2 load utility
Hi nishantrk DataStage uses the regular DB2 Load utility. I am a littl e surprised about the different durations you saw but DEL (Delimited ASCII) would always be my choice as ASC is only used when you get data in that format. Of cause differnt options can have a performance impact. Try to use API l...
- Tue Jul 22, 2014 9:41 am
- Forum: General
- Topic: Job needs to run each hour
- Replies: 4
- Views: 3232
Re: Job needs to run each hour
Hi _chamak
you could write a database trigger "on update" of that column. Then you check if it is set to 'Y' within the trigger and run a user defined function.
That UDF could then execute a OS command which runs dsjob to start the DataStage sequence (or job).
you could write a database trigger "on update" of that column. Then you check if it is set to 'Y' within the trigger and run a user defined function.
That UDF could then execute a OS command which runs dsjob to start the DataStage sequence (or job).
- Fri Jul 11, 2014 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to resolve WVARCHAR to DB2 table
- Replies: 14
- Views: 17262
- Fri Jul 11, 2014 2:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Stage to convert child repeating elements into rows
- Replies: 7
- Views: 5228
- Fri Jul 11, 2014 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to resolve WVARCHAR to DB2 table
- Replies: 14
- Views: 17262
Hi tbtcust, reading from a file into a DB2 UTF-8 database should be possible without warnings. Having UTF-8 for the database and as NLS in the DataStage job you could use the DB2CODEPAGE set to 1208. Make this a job parameter and do not user the extended unicode for the column and it will work witho...
- Wed Jul 09, 2014 12:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to resolve WVARCHAR to DB2 table
- Replies: 14
- Views: 17262
Hi tbtcust Some columns are as small as 1 and as large as 80. The database code set is UTF-8. OK - but is the specified length in DataStage the same as in DB2? For example if you have a length of 10 in DataStage - try using 40 in DB2 ( as a single character could be stored in up to 4 bytes using UTF...
- Wed Jul 09, 2014 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to resolve WVARCHAR to DB2 table
- Replies: 14
- Views: 17262
Re: Unable to resolve WVARCHAR to DB2 table
Hi tbtcust what is the column length in DataStage and in DB2? I suppose your database hast been created with UTF-8 and this means that a single character can be stored in 1,2,3 or even 4 bytes. Be aware that DB2 length specifications at the moment are in bytes (and not in characters). This can lead ...
- Thu Jul 03, 2014 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 - Bulk Load
- Replies: 1
- Views: 2537
Re: DB2 - Bulk Load
Hi Raftsman
the "Statistics" option is only valid if the LOAD MODE is replace.
This is due to regular DB2 LOAD functionality.
the "Statistics" option is only valid if the LOAD MODE is replace.
This is due to regular DB2 LOAD functionality.