I have modified a demo program from the Informix Client SDK to test the installation Environment Config # AIX ——————– export INFORMIXC=”gcc -maix64″ export SHLIB_PATH=${INFORMIXDIR/lib}:$INFORMIXDIR/lib/esql:${SHLIB_PATH} #AIX export THREADLIB=POSIX # Linux —————— export INFORMIXC=gcc # COMMON —————- export INFORMIXCC=${INFORMIXC} export LIBRARY_PATH=${INFORMIXDIR}/lib/esql:${LIBRARY_PATH} esql demo.ecc Demo Program #include EXEC SQL define FNAME_LEN 128; […]

For DBA Jr on Informix or DB2, i will show you a table with a list of environment variables thah work on Solaris, AIX and Linux operative systems with Informix and the equivalent at DB2. Use Informix DB2 Instance is Running onstat – db2ps – Dysplay Instance Messges onstat -m […]

#!/usr/bin/ksh ############################################## # # # Utileria para el respaldar dbs de db2 # # Jorge Ivan Contreras Pacheco # # ivan@contrerasmx.com # # v.1.0 16/12/2014 # # # ############################################## _OS=`uname -s` DB2HOME=/db2/db2inst1 if [ -f ${DB2HOME}/sqllib/db2profile ]; then . ${DB2HOME}/sqllib/db2profile fi case ${_OS} in Linux) CMD_ECHO=”echo -e ” CMD_LS_K=”ls –block-size […]