List of Contributions

Markus Fraune

Contact Details

My Content

1 to 15 of 15 total

RE: Simple Docker DB2 image setup fails

Posted By Markus Fraune Nov 9, 2020 11:20 AM
Found In Egroup: Db2 On Premise and Cloud \ view thread
Hi, I am still on 10.15.6 because 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 you somehow ...

RE: index usage

Posted By Markus Fraune Sep 30, 2020 2:48 AM
Found In Egroup: Db2 On Premise and Cloud \ view thread
optimization guidelines may help here. try something like this: select * from ttt where col2=? and col3 in (?,?,?) /* <OPTGUIDELINES> <IXSCAN TABLE='TTT' INDEX='COL3IDX'/> </OPTGUIDELINES> */ ------------------------------ Markus Fraune ------------------------------

RE: DB2 WH: Unable to restore an offline backup

Posted By Markus Fraune Sep 28, 2020 2: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 Sep 23, 2020 2:14 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Sep 22, 2020 2:19 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 May 29, 2020 3:27 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 May 15, 2020 2:50 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 May 13, 2020 3:02 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Mar 26, 2020 7:40 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 variable ...

RE: DB2 CREATE DATABASE WITH PAGESIZE

Posted By Markus Fraune Mar 26, 2020 3:45 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 place ...

RE: Docker image with DB2

Posted By Markus Fraune Mar 18, 2020 3:25 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Feb 11, 2020 3:23 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Feb 11, 2020 3:19 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Oct 28, 2019 11:22 AM
Found In Egroup: Db2 On Premise and Cloud \ 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 Oct 25, 2019 8:56 AM
Found In Egroup: Db2 On Premise and Cloud \ 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). -------- ...