DSXchange

Eric, Thanks.

thompsonp wrote:Does anyone have any updates on when the next version of Information Server will be released?

Per IBM's Software Announcement A17-0877, InfoSphere Information Server V11.7 will be available from December 21, 2017.

qt_ky wrote:There will also be another webinar next Tuesday. Are you getting the email invitations?

How did you signup for the webinar?

Post initial installation, Balanced optimization can be turned on/offthru iisAdmin.

Command to switch it ON:

Thank you. IBM's kinit gives RC of "0" with bad syntax also, though default kinit works ok ... $ /opt/IBM/InformationServer/jdk/jre/bin/kinit -~ oij com.ibm.security.krb5.KrbException, status code: 6 message: Client not found in Kerberos database $ echo $? 0 $ /usr/bin/kinit -~ oij /usr/bi...

IBM's latest JDK is installed on DataStage server. IBM's kinit is being used to generate kerberos ticket. This command generates a ticket for a limited time period and subsequently it needs to be renewed. We are invoking the command thru a scheduler to renew the ticket. Return code from this command...

I have tried reading using sequential file stage(Delimited as comma and Quotes as None), its not able to read 4 column. Craig, You have a point about embedded double quotes ... though with solution mentioned above, all columns are read, as embedded double quotes and commas etc no longer trip DataSt...

You can leverage Unix's capabilities to meet this requirement as given below: In Seq file stage's properties 1. Set value of FILTER to nawk -F\" 'BEGIN{OFS=FS;} {for(i=1;i<=NF;i=i+2){gsub(/,/,"~",$i);} print $0;}' This command will replace the "delimiter commas" with "~...

If you are using Operations Console, then following query will give desired results ... SELECT distinct X.ProjectName, X.FOLDERPATH, X.JobName, P.PARAMNAME, P.PARAMVALUE FROM DSODB.JOBRUN R JOIN DSODB.JOBEXEC X ON R.JOBID = X.JOBID JOIN DSODB.JOBRUNPARAMSVIEW P ON R.RUNID = P.RUNID WHERE P.PARAMNAME...

This can be achieved by use of transformer stage variables: Note: In the job, either run Sort and Transformer stages in Sequential mode or hash by FsclYr. 1. Sort incoming data by FsclYr, MthNum. 2. In transformer 2.1. Create following stage variables IF in.FsclYr <> svFsclYr THEN In.Amt ELSE (svYTD...

Thank you. Failure was due to convergence of two issues: 1. Bad Keytab. Cloudera admin recreated the keytab file for this. 2. Kerberos ticket was generated using knit from "/usr/sbin/". Ticket had to be regenerated using kinit from IBM's JDK: $ kdestroy $ /opt/IBM/InformationServer/jdk/jre...

Please see response below preceded by "=>". Is it normal that lookup does not support only the reject link ? => Yes. May be in that case, is it better i write the sql query in the oracle conncetor instead of doing that using lookup. => You can send the "matched" output records to...

DataStage 11.501; Patches applied: Datadirect JDBC Driver for Hive(JR56156) and Hive Connector(JR56097). We are trying to use File Connector stage for connecting to Cloudera Hadoop server. Connection parameters are: FileSystem: HttpFS Use Custom URL: No Use SSL: Yes Use Ketab: Yes Use Kerberos: Yes ...

TNZL_BI wrote:The new problem now is that the performance of the Hive connector stage is pathetic. Opened a case with IBM.. will give all the details if I hear anything positive

What did IBM suggest? Did it help?

Connection to Azure SQL database from DataStage using JDBC with following connection string works ok: jdbc:ibm:sqlserver://azrdevstore.database.windows.net:1433;database=AZR_DEV;EncryptionMethod=SSL;ValidateServerCertificate=true;CryptoProtocolVersion=TLSv1.2; Subsequently to establish ODBC connecti...

Another criteria to think about is availability of features and support. There are variations in DataStage features based on operating system e.g. BDFS was initially launched only for linux and about 1+ year later made available for AIX and that too for connectivity to BigInsights only. These variat...