Servidor RDBMS Informix Dev. Edition (IDS) corriendo en un contenedor.
Luego de usarlo y administrarlo durante años, es algo muy “clásico”, “confiable” y en ciertas situaciones “muy rápido”.
Instalaremos un Informix Developer version 12.10., IDS es Informix Database server con muy poquitas restricciones, es gratuito y libro de usar para desarrollo, también incluye la suite completa de funciones del motor “FULL”.
Descargamos la imágen.
# docker pull ibmcom/informix-developer-database
Ponemos a correr un Contenedor.
# docker run -it --name iif_developer_edition --privileged -p 9088:9088 -p 9089:9089 -p 27017:27017 -p 27018:27018 \
-p 27883:27883 -e LICENSE=accept ibmcom/informix-developer-database:latest
La imágen pesa 1.68 GB y es la version 12.10 dev edition.
# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
ibmcom/informix-developer-database latest 8fa5f8f1ea51 2 months ago 1.68GB
Poner a correr el contenedor necesita 154 mb.
# docker stats
CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS
934a14dbc122 iif_developer_edition 0.19% 154.5MiB / 7.681GiB 1.96% 152kB / 108kB 1.18MB / 171MB 162
El contenedor corriendo.
# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
934a14dbc122 ibmcom/informix-developer-database:latest "/bin/bash informix_…" About a minute ago Up About a minute 0.0.0.0:9088-9089->9088-9089/tcp, 0.0.0.0:27017-27018->27017-27018/tcp, 0.0.0.0:27883->27883/tcp iif_developer_edition
top - 11:26:28 up 3:03, 0 users, load average: 0.37, 0.41, 0.40
Tasks: 12 total, 1 running, 11 sleeping, 0 stopped, 0 zombie
%Cpu(s): 10.2 us, 2.5 sy, 0.0 ni, 87.1 id, 0.0 wa, 0.0 hi, 0.2 si, 0.0 st
KiB Mem: 8053968 total, 6391224 used, 1662744 free, 172428 buffers
KiB Swap: 4096120 total, 23040 used, 4073080 free. 1637432 cached Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
372 informix 20 0 21952 2464 2084 R 0.3 0.0 0:00.56 top
1 informix 20 0 20092 2884 2584 S 0.0 0.0 0:00.05 bash
161 informix 10 -10 205576 165952 162788 S 0.0 2.1 0:01.30 oninit
162 root 10 -10 205576 7280 4132 S 0.0 0.1 0:00.23 oninit
163 root 10 -10 205576 6312 3164 S 0.0 0.1 0:00.06 oninit
164 root 10 -10 205576 6256 3108 S 0.0 0.1 0:00.05 oninit
165 root 10 -10 207632 12796 9640 S 0.0 0.2 0:00.15 oninit
166 root 10 -10 205576 7392 4244 S 0.0 0.1 0:00.00 oninit
167 root 10 -10 205576 5300 2152 S 0.0 0.1 0:00.05 oninit
168 root 10 -10 205576 7228 4076 S 0.0 0.1 0:00.50 oninit
186 informix 20 0 4651468 146984 16872 S 0.0 1.8 0:07.91 java
210 informix 20 0 20264 3268 2776 S 0.0 0.0 0:00.02 bash
Como parar y arrancar el contenedor.
# docker stop iif_developer_edition
# docker start iif_developer_edition
Como conectarnos a una sesión shell contra el servidor.
# docker exec -it iif_developer_edition bash
Usamos la herramienta Texto para interactuar con el motor (dbaccess)
IDS-12.10 dev: dbaccess
SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Run the current SQL statements.
----------------------- test1@dev -------------- Press CTRL-W for Help --------
create table t1 (id int);
DBACCESS: Query-language Connection Database Table Session Exit
Retrieve information about the current DB-Access session.
----------------------- test1@dev -------------- Press CTRL-W for Help --------
Server
dev
Dynamic Server
Connected to host934a14dbc122
Multi-threaded
Server Capabilities
NLS
Distributed
XA
NLS Capabilities and Attributes
en_US.819 Collating Sequence
en_US.819 CType
Desde el shell podemos interactuar con ese S. O.
IDS-12.10 dev: pwd
/opt/IBM/informix
IDS-12.10 dev: ls -ail
total 560
13111411 drwxr-xr-x 1 informix informix 4096 Dec 21 10:34 .
13111410 drwxr-xr-x 1 root root 4096 Oct 6 20:35 ..
13111412 -rwxr-xr-x 1 root root 90093 Oct 6 20:34 Global_Language_Support_Install_10_06_2017_20_34_11.log
13111413 -rwxr-xr-x 1 root root 180378 Oct 6 20:34 IBM_Informix_12.10_Install_10_06_2017_20_34_43.log
13111414 -rwxr-xr-x 1 root root 14236 Oct 6 20:35 IBM_Informix_Software_Bundle_Install_10_06_2017_20_34_03.log
13111415 -rwxr-xr-x 1 root root 71256 Oct 6 20:34 Informix_Client-SDK_Install_10_06_2017_20_34_18.log
13111416 -rwxr-xr-x 1 root root 61212 Oct 6 20:35 JDBC_Driver_Install_10_06_2017_20_35_01.log
13111417 drwxr-xr-x 4 informix informix 4096 Oct 6 20:34 SDK
13111430 drwxrwxr-x 2 informix informix 4096 Oct 6 20:34 aaodir
13111433 drwxr-xr-x 5 informix informix 4096 Oct 6 20:35 bin
13111616 drwxrwxr-x 2 informix informix 4096 Oct 6 20:34 dbssodir
13111619 drwxr-xr-x 11 informix informix 4096 Oct 6 20:34 demo
13111950 drwxr-xr-x 3 informix informix 4096 Oct 6 20:34 doc
13112039 drwxrwxr-x 1 informix informix 4096 Dec 21 10:34 etc
13112248 drwxr-xr-x 20 informix informix 4096 Oct 6 20:34 extend
13112645 drwxr-xr-x 1 informix informix 4096 Dec 21 10:33 gls
13113410 drwxr-xr-x 2 informix informix 4096 Oct 6 20:35 gskit
13113415 drwxr-xr-x 4 informix informix 4096 Oct 6 20:34 help
13113687 drwxr-xr-x 9 informix informix 4096 Oct 6 20:34 incl
13113791 drwxr-xr-x 3 informix informix 4096 Oct 6 20:35 isa
13113844 drwxrwxr-x 7 root root 4096 Oct 6 20:35 jdbc
13116371 -rw-r--r-- 1 informix informix 21938 Dec 21 10:34 jsonListener_logging.log
13114309 drwxr-xr-x 5 root root 4096 Oct 6 20:35 jvm
13115936 drwxr-xr-x 8 informix informix 4096 Oct 6 20:34 lib
13116014 drwxrwxr-x 2 root root 4096 Oct 6 20:34 license
13116034 drwxr-xr-x 3 informix informix 4096 Oct 6 20:34 msg
13116121 drwxr-xr-x 3 informix informix 4096 Oct 6 20:34 properties
13116124 drwxr-xr-x 3 informix informix 4096 Oct 6 20:34 release
13116140 drwxrwxr-x 2 root root 4096 Oct 6 20:34 sdk_license
13116160 drwxr-xr-x 3 informix informix 4096 Oct 6 20:34 snmp
13116170 drwxrwx--- 2 informix informix 4096 Oct 6 20:35 ssl
13116171 drwxrwx--- 1 informix informix 4096 Dec 21 10:33 tmp
13116174 drwxrwxr-x 6 informix informix 4096 Oct 6 20:35 uninstall
Carpeta donde se instala el motor Informix.
/opt/IBM/informix
* 9088 Puerto de acceso TCP
* 9089 Puerto para conecciones DRDA
* 27017 Puerto para conecciones Mongo
* 27018 Puerto para acceso REST
* 27019 Puerto para acceso MQTT
IDS-12.10 dev: onstat -s
IBM Informix Dynamic Server Version 12.10.FC9W1DE -- On-Line -- Up 01:01:16 -- 156276 Kbytes
Latches with lock or userthread set
name address lock wait userthread
IDS-12.10 dev: onstat -k
IBM Informix Dynamic Server Version 12.10.FC9W1DE -- On-Line -- Up 01:03:30 -- 156276 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
44199028 0 44cabbd8 0 HDR+S 100002 204 0
441992d0 0 44cab2e8 0 S 100002 204 0
44199358 0 44cab2e8 441992d0 HDR+S 100002 201 0
441993e0 0 44caa9f8 0 S 100002 204 0
44199468 0 44cac4c8 0 S 100002 204 0
5 active, 20000 total, 16384 hash buckets, 0 lock table overflows
La clave standard para “root” es “in4mix”.