Search found 406 matches

by JRodriguez
Thu Mar 29, 2018 10:17 am
Forum: General
Topic: Kafka logs on Service tier
Replies: 5
Views: 5032

It should be ok to add the new parameter to the configuration manually. My preference is to use the commands provided to do all the maintenance tasks A Topic is just a stream of records, In the Kafka or streaming world is called topic. For Information Server the default name of the topic is Infosphe...
by JRodriguez
Thu Mar 29, 2018 9:13 am
Forum: General
Topic: Kafka logs on Service tier
Replies: 5
Views: 5032

Two ways come to my mind: 1) change the retention period for events on the topic $InstallPath/shared-open-source/kafka$ update-config.sh --zookeeper serverName:port --entity-type topics --alter --add-config retention-ms=500 --entity-name InfosphereEvents 2) delete the topic. It will be automatically...
by JRodriguez
Thu Mar 29, 2018 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Filter - Run in one project, not the other
Replies: 4
Views: 3809

Did you compile the code in Project B after importing the parameterSet??
by JRodriguez
Wed Mar 28, 2018 6:22 am
Forum: General
Topic: Connecting to Designer/Director from command line
Replies: 6
Views: 4754

Thanks to both of you. My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxury of recycling the services in the middle of the day I will explore Ray's suggestions A good news is th...
by JRodriguez
Wed Mar 28, 2018 6:22 am
Forum: General
Topic: Connecting to Designer/Director from command line
Replies: 6
Views: 4754

Thanks to both of you. My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxury of recycling the services in the middle of the day I will explore Ray's suggestions A good news is th...
by JRodriguez
Tue Mar 27, 2018 6:46 am
Forum: General
Topic: Connecting to Designer/Director from command line
Replies: 6
Views: 4754

Connecting to Designer/Director from command line

Hello All, Is there a way to check from command line that a connection could be established from the DataStage clients to Information Server? We have a validation script to test the health of our ETL infrastructure but in case that a connection can not be established to the clients Production Suppor...
by JRodriguez
Thu Feb 08, 2018 6:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: What is ODF and where is it documented?
Replies: 5
Views: 17011

IBM Information Server Open Discovery Framework (ODF) In the latest versions of Information Server IBM added open source services, specifically the Apache Framework (Zookeeper, Kafka,solr) and there are several Technotes in how to configure these services. In the last version 11.7.0.0 they added the...
by JRodriguez
Wed Dec 13, 2017 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UTF-8 to UTF-16 conversion in Datastage
Replies: 1
Views: 5952

Hi Matt, Internally DataStage parallel jobs use UTF-16 encoding by default regardless of the encoding of sources and targets. It means that internally the data from one stage to the next flows already encoded in UTF-16 and there is not need to use functions to convert from one encoding to another in...
by JRodriguez
Wed Oct 25, 2017 5:34 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: "error": "SELF_SIGNED_CERT_IN_CHAIN"
Replies: 1
Views: 14323

This is the light version of the procedure. Do your company have a WAS administrator? If yes then ask for help to that group, the procedure is straightforward for a WAS person. If not then just follow the process and ask in the forum if any issues As per the certificate, you could use one generated ...
by JRodriguez
Wed Oct 11, 2017 5:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Throttle a DS Parallel job which invokes a Rest Service
Replies: 3
Views: 3471

Well normally we are asked to speed up processes..but it could be done. Here is one way To the request table add a column to flag the requests records as processed/not processed. Default the value to "N" on insert. I would guess that you have a DS sequence...so After the DS that populate t...
by JRodriguez
Wed Sep 27, 2017 5:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unicode Property at Project Level
Replies: 2
Views: 2499

I believe that the only option at that point -after importing the metadata to the DS jobs- is manually changing the property to Unicode or changing the type to NVarchar/NChar

Yo could try hacking a dsx export file and the reimport but that could become messy easily
by JRodriguez
Wed Sep 20, 2017 11:55 am
Forum: General
Topic: istools does not recognise -informationanalyzer option
Replies: 10
Views: 10430

We are at 11.5.0.2 and able to see the Information Analyzer import options...See last line ./istool.sh import -help istool import [ Options ] Possible values for: Options Long Name: Short Name: Description: -help , -h : print command usage -domain , -dom : Name of Information Server domain -username...
by JRodriguez
Sat Sep 16, 2017 1:39 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to process/output only the first of multiple records
Replies: 1
Views: 12360

Hi Manito,
How about a virtual table to represent the right table with the desired records to return only one when joining with the left table? Of course you would need to use regular SQL techniques to get the table as you want...

Another way will be to do the entire join in a virtual table
by JRodriguez
Tue Sep 12, 2017 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unicode with RCP?
Replies: 11
Views: 12205

The Oracle client needs to know the NLS of the target database, just set DS job to go by the NLS of the target database, here is how is done: -Get the NLS of Oracle database - Add a NLS_LANG to user defined environmental variables in DS Admin Client. Leave the value empty - Add the $NLS_LANG as a pa...