List of Contributions

Markus Fraune

Contact Details

My Content

1 to 18 of 18 total

RE: Running DB2 on Apple M1 (ARM) laptop in Docker

Posted By Markus Fraune Wed February 09, 2022 02:07 AM
Found In Egroup: Cloud Pak for Data \ view thread
Hi, basically Docker Desktop should do the job. No need to convert as the linux inside the docker vm will emulate x86. You only need to specificy the platform parameter to tell docker to run the x86 image and do not search for an arm based native version. Try something like this: docker run -itd --platform ...

RE: db2c_db2inst1 service port changed to 25010 with ibmcom/db2 docker latest, 11.5.6.0

Posted By Markus Fraune Mon September 13, 2021 04:46 AM
Found In Egroup: Db2 \ view thread
hi, had the same "issue" ... the first and following restarts will work as before and reset your /etc/services to port 50000 and to your question: yes, there is an explanation: with 11.5.6 IBM changed default db2 port to 25000. for example documented here: https://www.ibm.com/support/product ...

RE: db2 docker persistent volume

Posted By Markus Fraune Thu August 12, 2021 03:20 AM
Found In Egroup: Db2 \ view thread
Hi Guy, at first: a persistent volume in docker is not the same as virtual volume in a vm. its not an iso / file that can easily be "shipped". to export/ship/import a volume you can go through the following steps (docker as root and same docker host OS - remember to set you env varas correct if ...

RE: Simple Docker DB2 image setup fails

Posted By Markus Fraune Mon November 09, 2020 11:21 AM
Found In Egroup: Db2 \ view thread
Hi, I am still on 10.15.6 because @Michael Krafick wrote on Twitter that he had issues starting db2 on docker on mac with latest mac release.... I assume that you already checked the docker prefs. -> resources -> file sharing if your folder (or a parent one) is shared? Mike, can you assist here? Could ...

RE: index usage

Posted By Markus Fraune Wed September 30, 2020 02:49 AM
Found In Egroup: Db2 \ view thread
optimization guidelines may help here. try something like this: select * from ttt where col2=? and col3 in (?,?,?) /* */ ------------------------------ Markus Fraune ------------------------------

RE: DB2 WH: Unable to restore an offline backup

Posted By Markus Fraune Mon September 28, 2020 02:02 AM
Found In Egroup: Cloud Pak for Data \ view thread
hi, seems as you are not alone on the database when executing the restore. have you executed all the prio steps like db2stop, force applications deacivate db and so on? if yes, look for open connection right before the restore command with "db2 list applications". if there are any force off, wait for ...

RE: db2diag filter

Posted By Markus Fraune Wed September 23, 2020 02:15 AM
Found In Egroup: Db2 \ view thread
hi Guy, can you give as an example db2diag.log entry that you want to be alerted and one you don't want? ------------------------------ Markus Fraune ------------------------------

RE: Bug report: Docker image should support DB2INST1_PASSWORD as *secret* not only as environment variable

Posted By Markus Fraune Tue September 22, 2020 02:20 AM
Found In Egroup: Db2 \ view thread
I think it is more or less a question for the ibm developers, but: secrets can only be used within a service / swarm (productive usage) -> created your own image based on ibmcom/db2 and access the secrets to set instance user password (and maybe additional ones for other OS users). for testing systems ...

RE: Bulk Deletion with Batch

Posted By Markus Fraune Fri May 29, 2020 03:27 AM
Found In Egroup: Db2 \ view thread
Hi Prashant, I recommend to use compound sql, deleting over a cursor (with batchsize to be defined and inserting status in status table). Where clause can be changed to e.g. have batches to be executed in parallel by separating by you mentioned seq_ID. same sample code (put in a file and execute file ...

RE: Simple Docker DB2 image setup fails

Posted By Markus Fraune Fri May 15, 2020 02:50 AM
Found In Egroup: Db2 \ view thread
Hi Jürgen, Docker on Windows needs Hyper-V to run its Linux machine. As Hyper-V is not available by default on Windows 10 Home, you will receive those errors. Search for Windows 10 Home Hyper-V and you will finde some easy instructions on how to activate even if not possible via system settings (you ...

RE: Simple Docker DB2 image setup fails

Posted By Markus Fraune Wed May 13, 2020 03:02 AM
Found In Egroup: Db2 \ view thread
Hi David, seems as you are running docker on windows. Have a look for this parameter: PERSISTENT_HOME is true by default, only specify to false if you are running Docker for Windows. Set it to false and try to create container again. ------------------------------ Markus Fraune ...

RE: DB2 CREATE DATABASE WITH PAGESIZE

Posted By Markus Fraune Thu March 26, 2020 07:40 AM
Found In Egroup: Db2 \ view thread
Hi, you should remove the old license with db2licm -r. Best would be to include your license in your own db2 image. 2 Options here 1) Copy your license file to the folder /var/db2_setup/include e.g.: COPY db2stand.lic /var/db2_setup/include/. and with run/create of the container set the env ...

RE: DB2 CREATE DATABASE WITH PAGESIZE

Posted By Markus Fraune Thu March 26, 2020 03:45 AM
Found In Egroup: Db2 \ view thread
Hi, you can get a problem when migrating to v-next of db2 docker image. you should considere not to create a database via ibm scripts using the environment variable but instead use your own script to create a database. in your new docker file you should at first create the directory /var/custom and ...

RE: Docker image with DB2

Posted By Markus Fraune Wed March 18, 2020 03:25 AM
Found In Egroup: Db2 \ view thread
Hi, the official ibm db2 image has some persistent volumes / bind mounts. With docker commit command you are only persisting the non persistent layers / thin-rw layers layers. e.g. /opt is now within your new committed image, but /database is not (its a persistent volume). therefore you get the error ...

RE: trying to use DB2 as part of docker-compose.yml

Posted By Markus Fraune Tue February 11, 2020 03:23 AM
Found In Egroup: Db2 \ view thread
hi, do not use command until you have a valid start up script. the command option overrides the default image entrypoint script. which in a db2 case creates the instance, adds users, makes config etc. without this startup script you do not have a running instance. for your specific case: delete the command ...

RE: Looking for db2 11.1 docker image

Posted By Markus Fraune Tue February 11, 2020 03:19 AM
Found In Egroup: Db2 \ view thread
Hi, it is available until 31st July this year but under a different repo. Try the following (and maybe upload it to your own registry to save it for later installations): docker pull store/ibmcorp/db2_developer_c:11.1.3.3-x86_64 ------------------------------ Markus Fraune --------- ...

RE: How to setup HADR on an already existing dockers

Posted By Markus Fraune Mon October 28, 2019 11:22 AM
Found In Egroup: Db2 \ view thread
Hi, hadr on docker works the same as on a "normal" system. the difference within docker is that name resolving does only work for the container name, not for the hostname. so either try to use the container name of the primary and secondary container or insert the internal IP address of those containers ...

RE: How to setup HADR on an already existing dockers

Posted By Markus Fraune Fri October 25, 2019 08:56 AM
Found In Egroup: Db2 \ view thread
Hi, what did you set for HADR_LOCAL_HOST (and for remote as well)? As RC4 means it cant resolve its hostname. Be sure to set correct hostnames in the db cfg and that the names can be resolved (in docker: either use /etc/hosts or use dns given by docker using a user defined bridge network). --- ...