tips and tricks

Hi All;

*For Informacitca 9.5.1. Hot fix 2 preistallation check list please click here

This is my Informatica 9.5.1 preinstallation check list for IBM AIX.

1. Download Informatica software 9.5.1 HF1 for AIX from my.informatica.com via Global Customer Support.
2. Get the correct licence files from Global Customer support
3. Install Java version 6.
   http://www.ibm.com/developerworks/java/jdk/aix/service.html#java6
4. Install JDK 1.6.0 build pap6460sr9fp2-20110627_03(SR9 FP2) exactly.
   http://pic.dhe.ibm.com/infocenter/sb2bi/v5r2/index.jsp?topic=%2Fcom.ibm.help.sys_rqmts.doc%2FSysRqmts_DwnldAIXJDK.html
5. There are some problems with AIX TAR, Install GNUTAR.
   http://www.gnu.org/software/tar/
6. Create User for informatica. (ex: infa, infauser, etluser... etc.)
7. Set u limit to 16.000 (or unlimited.)
   set ulimit -n to 16000
8. Create a database user for each Power Designer domain. (ex: INFADOM)
9. Create a database user for each Power Designer repository. (ex: INFAREP)
10. Verify that the database users have CONNECT, RESOURCE, and CREATE VIEW privileges.
11. For Oracle repositories Set the open_cursors parameter to 1000 or higher
12. If exist, open the following port range: 6000 to 6113 on firewall.
13. Do not believe curse of 13.
14. Reserve at least 1GB for Domain and repository database space (both users in the same tablespace)
15. Reserve at least 30GB file system space for installation on the server

It'is realy unique and easy to substract dates in Oracle.

If you select

SELECT TO_DATE ('01/02/2013 11:07:16','DD/MM/YYYY HH24:MI:SS') - TO_DATE('01/02/2013 11:03:37','DD/MM/YYYY HH24:MI:SS') FROM DUAL;

Result is:
0,00253472222222222


To achive same result in Sybase IQ correct syntax is:
SELECT CONVERT(NUMERIC(16,10), DATEDIFF(SECOND,  CONVERT(TIMESTAMP, '2013-02-01 11:03:37'), CONVERT(TIMESTAMP, '2013-02-01 11:07:16'))) / 60 / 60 / 24


DATEDIFF: Datepart, Small date, Big date returns: INT

Tric is converting datediff result to numeric :)

1.1            Defining connection for Sybase Central and connectng to database

Open Sybase Central for Java edition

 

"Choose Connection Profiles"

 

Choose "New" to define name & description

Click OK to choose or define ODBC connection

Important: To choose previously defined ODBC connections use

Browse..àShow all data sources .

 

Double click or choose connect:

 

1.2           Choosing code to debug and search criteria management

Choose Procedures & Functions

Define filter in SQL like format

You may use settings buton to filter on users

Important: You have to use submit buton to apply search criteria

 

1.3            Debug mode

Double click on code to open in editor.

Choose dubug button to switch debug mode

 Important: Choose only debug DB user to prevent affecting other users

 

1.4            Break point tanımlanması ve kodun debug modda çalıştırılması

Click on the left side to define break point

Call procedure using a querry tool

 

 

 

 

to get folder size in readable format use
du -gs *| sort -n

click for SUN Solaris command

One of the best ways to send HTML mail from SybaseIQ on IBM AIX is to use sendmail.
Unfortunately sendmail has linelength limit (2040 characters default). After 2040th character sendmail is adding ! and new line characters to text which is ruining HTML.

To fix this problem:

1. Change Linelimit info in Sendmail.cf file. Add L=4096 (or any other suitable value) to corresponding mailer.
2. To identify correct mailer check mail log at /var/log/maillog file. Mailer name is mostly Mrelay
3. After these steps ! character shall be removed from your mail.
4. You may add ||  CHAR(13) || CHAR(10) after each </tr> statement to add new line in SQL as well.

Sample script which sends HTML mail from Sybase IQ is below