informix/informix-server-dockerfiles

informix-server-dockerfiles's Issues

Onconfig and sqlhosts files missing

Hi,

I built a container with the scripts and executed it on K8S.

When the container restart (e.g. after a node not available), the onconfig and sqlhost are missing into the directory $INFORMIXDIR/etc/.

I think it's due to the fact that the links are created into the scripts "onconfig_setup.sh" and "sqlhosts_setup.sh" but are not created when the database is already initialized.

I think that we need to call the "setup_links.sh" script into the "entry.sh" script when the database is already initialized.

Could you please check?

Regards,
Renaud

Error in vCPUS computing

Hi,

I built a container with the scripts and executed it on K8S.

I have an error on vCPU computing when running on IBM K8S cluster. I give 2 CPU to the Informix container.

The value of vCPU_CONTAINER returned by the container (in the script "calculate_onconfig.sh") is 40000.

informix@informixdb-0:/opt/ibm/config$ cat /sys/fs/cgroup/cpu/cpu.cfs_quota_us
40000
informix@informixdb-0:/opt/ibm/config$ cat /sys/fs/cgroup/cpu/cpu.cfs_period_us
20000

When I run the same command in a docker on my laptop (CentOS), I get the following values.

informix@informixdb-0:/opt/ibm/config$ cat /sys/fs/cgroup/cpu/cpu.cfs_quota_us
200000
informix@informixdb-0:/opt/ibm/config$ cat /sys/fs/cgroup/cpu/cpu.cfs_period_us
100000

I think the right formula to compute the number of vCPU allocated to the container is the following:

CPUFILE_QUOTA="/sys/fs/cgroup/cpu/cpu.cfs_quota_us"
CPUFILE_PERIOD="/sys/fs/cgroup/cpu/cpu.cfs_period_us"

vCPUS_CONTAINER_QUOTA=`cat $CPUFILE_QUOTA`
vCPUS_CONTAINER_PERIOD=`cat $CPUFILE_PERIOD`

###
### Set the amount of CPU's available to the docker container
###
if [[ $vCPUS_CONTAINER == "-1" ]]
then
   vCPUS=$vCPUS_HOST
else
   vCPUS=`echo "$vCPUS_CONTAINER_QUOTA / $vCPUS_CONTAINER_PERIOD" | bc`
fi

Could you please check?

Regards,
Renaud

GSkit not installed

Hi,

I built a container with the scripts and executed it on K8S.

When the container restart (e.g. after a node not available), the GSKit utility is no more installed.

I think it's due to the fact that GSKit is only installed when the database is not initialized and not during a "restart".

I think that we need to uncomment the line with GSKit installation when the database is not initialized.

Could you please check?

Regards,
Renaud

Running RSS

I setup 2 docker hosts with the same docker image. On both hosts I run a container with a different hostname and dbinstance name. I have updated the hostname, onconfig and sqlhosts. I can access the databases on both docker images when started initially with dbaccess. I am able to connect from the dbaccess in container 1 to the database from the other container.

Trying to do a RSS replication
Perform the requirements on the primary:

$cat /opt/ibm/informix/etc/sqlhosts
############################################################
### DO NOT MODIFY THIS COMMENT SECTION 
### HOST NAME = ifxprim 
############################################################
g_mach11  group     -         -          i=10 g=g_mach11
rss_primary        onsoctcp        ifxprim         9088 g=g_mach11
rss_primary_dr     drsoctcp        ifxprim         9089 g=g_mach11
rss_replica        onsoctcp        ifxrep         9088 g=g_mach11
rss_replica_dr     drsoctcp        ifxrep         9089 g=g_mach11

$onmode -wf LOG_INDEX_BUILDS=1
$onmode -d add RSS rss_replica
$ onstat -g rss

IBM Informix Dynamic Server Version 12.10.FC10 -- On-Line -- Up 00:25:16 -- 65396 Kbytes

Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2019/09/20 16:34:51
Number of RSS servers: 1

RSS Server information:

RSS Srv      RSS Srv      Connection     Next LPG to send        Supports
name         status       status           (log id,page)         Proxy Writes
rss_replica Defined      Disconnected            0,0            N

Making a backup on the primary
ontape -s -L 0 -d -t /home/informix/backup
After that I copied the data to the other host. And restored it on the second docker container.

$cat /opt/ibm/informix/etc/sqlhosts
############################################################
### DO NOT MODIFY THIS COMMENT SECTION 
### HOST NAME = ifxrep 
############################################################
g_mach11  group     -         -          i=10 g=g_mach11
rss_replica        onsoctcp        ifxrep         9088 g=g_mach11
rss_replica_dr     drsoctcp        ifxrep         9089 g=g_mach11
rss_primary        onsoctcp        ifxprim         9088 g=g_mach11
rss_primary_dr     drsoctcp        ifxprim         9089 g=g_mach11
ontape -p -d -t /home/informix/backup/
$ onstat -
IBM Informix Dynamic Server Version 12.10.FC10 -- Fast Recovery -- Up 00:01:30 -- 72764 Kbytes
$ onmode -d RSS rss_primary
RSS Server did not successfully start.
onmode: Please check the message log for errors.
$ tail -n 25 /opt/ibm/data/logs/online.log |head -n 4
Maximum server connections 0
DR: new type = RSS
DR: Trying to connect to server, rss_primary. If the specified server is not in Online mode, bring it to Online mode.
Data replication type and state information reset. To start DR, use the 'onmode -d' command and wait for the pair to be operational, before shutting down the database server

Is this an informix issue, a docker issue, or did I miss a step?

Centos

It would be great if this was on Cent... Oh! 👍

init_sch_<servername>.sql files not adjusting to DBSERVERNAME env var

When creating a container using -e DBSERVERNAME=my_name, you'd still end up with a $INFORMIXDIR/etc/sysadmin/init_sch_informix.sql file rather than init_sch_my_name.sql.

informix_entry.sh would be the place to change this.

Update scripts to last version

Hi @darint00 ,

By checking the official docker image 'ibmcom/informix-developer-database', I see that the scripts used into the image are different from the scripts of this repository.
Could you please update this repository with the last version of the scripts?

Thank in advance.
Regards,
Renaud

Replace sed with SED

Hi,

I built a container with the scripts and execute it on K8S.

I have an error with the onconfig file. I have a duplicate onconfig file :

• The first into /opt/ibm/config/. It's the one that must be used by informix to keep the configuration between container restart ;
• The second one into /opt/ibm/informix/etc/. It should be a symlink to the first one.

The second onconfig file is created because of "sed -i" commands without the "--follow-symlinks".
I see that "SED" command was created. I think we need to replace all "sed -i" with "SED".

Could you please analyze?

Regards,
Renaud

Refresh

Can this repo get a refresh?

Thanks

Do you still need dinit?

Docker comes with Tini built in now

Huge Pages

Hi,

I built a container with the scripts and execute it on K8S.

I checked the Informix configuration and I see that the server does not create huge pages.
I would like to use huge pages for performance reasons.

Do you think it's possible to configure the Informix server, docker container or K8S cluster (IBM Cloud public) to allow Informix using huge pages?

Thanks.
Regards,
Renaud