I have to start saying, I just jump in DB2 world and this is my contribution to another beginners. The list of commands to start to use the DB2 engine. Global Use INSTHOME/sqllib/adm/db2licm -a filename register a DB2 license key by entering the db2licm -l c db2val validar instalacion db2level […]
Tag: db2
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 Name $INFORMIXSERVER $DB2INSTANCE Installation Directory $INFORMIXDIR $DB2_HOME
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 […]
#!/bin/bash function usage { echo -e “\t ${0} ” echo “” echo -e “donde : es la bases de datos ” # echo -e ” es el tipo de objeto ” # echo -e ” t – table ” echo -e ” es el nombre del objeto ” echo “” […]
#!/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 […]