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: databases
There is no excerpt because this is a protected post.
Set of scripts to monitor a Informix’s Instance
The development teams usually forgets calculate the size of databases’s modele. The spreadsheet can help them to make the sizing for each table of the model. You should make some changes: Adjust the Page Size, the acceptable values can be 2,4,8 and 16. At Rows Amount, write the total record […]
Like everything, the life of informix’s tables has some restrictions arround their grown in tree aspects: Avaible space in the dbspace Pages Used in each fragment Number of extents asigned The next query help us to find the tables in the instance, whom are near to touch their limit of […]
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 […]