List of Contributions

Guy Przytula

Contact Details

My Content

1 to 20 of 50+ total

RE: table partition

Posted By Guy Przytula Sat February 18, 2023 10:51 AM
Found In Egroup: Db2 \ view thread
you just get an sql error - no partition available ..... -- Best Regards, ????????Beste Groeten, ???????? Meilleures Salutations Guy Przytula ?? Tel. GSM??: +32 (0)475-33.81.86 Email : Guy Przytula ?????????????????????????????????? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?????? ...

federation to mongodb

Posted By Guy Przytula Fri January 14, 2022 05:34 AM
Found In Egroup: Db2 \ view thread
customer is having db2 11.5 installed on linux and also mongodb now we want to create a db2 nickname to access documents as per doc : create wrapper :ok create server:ok create user mapping:ok create nickname : this is the difficulty : i have a doc as in picture and tried to access typeCode ...

RE: cdc connection

Posted By Guy Przytula Tue December 14, 2021 02:43 AM
Found In Egroup: Db2 \ view thread
many thanks for the update would you mind sharing the link to that doc, or a simple example how to start with this, and I could build on top of this example. I will also search myself and see if getting there ------------------------------ Thank for all update/help Best Regards, Guy Przytula ...

cdc connection

Posted By Guy Przytula Sat December 04, 2021 04:23 AM
Found In Egroup: Db2 \ view thread
i know it is not really related to db2, but there is no community for CDC we have cdc connected to db2 luw on linux when we do a deploy of ddl in db2, we want to check if the table is replicated by cdc to avoid the subs to stop is there somewhere a doc that explains how to connect/consult data from ...

RE: db2 docker persistent volume

Posted By Guy Przytula Thu August 12, 2021 04:10 AM
Found In Egroup: Db2 \ view thread
many thanks for the info has been tested/done ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------

db2 docker persistent volume

Posted By Guy Przytula Wed August 11, 2021 03:30 AM
Found In Egroup: Db2 \ view thread
as a specific user is having a problem to create a database in a docker environment on windows he requested me to create the database on a persistent volume on my machine (where it worked) and shipping him this volume is there any documentation on how to proceed for a persistent volume in a docker ...

tsa or pacemaker

Posted By Guy Przytula Tue August 10, 2021 08:02 AM
Found In Egroup: Db2 \ view thread
for the moment we are using tsa to control the db2 cluster, but as pacemaker is coming closer we have to be prepared. the problem is : we have also CDC installed. we installed cdc on an nfs that is shared between primary and standby and created start/stop/monitor scripts for the integration of cdc in ...

lobs replication

Posted By Guy Przytula Mon August 02, 2021 03:18 AM
Found In Egroup: Db2 \ view thread
another question for which I could not find any info is how to replicate lobs or to define the lob-locater ? this for sql replication any doc that would help on this topic ? In the knowledge center I could see it is supported, but how to define ? ------------------------------ Thank for all update/help ...

sql replication profile

Posted By Guy Przytula Mon August 02, 2021 03:16 AM
Found In Egroup: Db2 \ view thread
I know sql replication is not popular and they want us to use cdc, but this customer wants to migrate from linux big endian to little endian and there is no cdc for linux big endian. we use replication center to define replication. I can see in options you can specify the preferred naming for cd tables ...

dmc and compress

Posted By Guy Przytula Wed July 14, 2021 03:53 AM
Found In Egroup: Db2 \ view thread
we have installed dmc on a server with ese, but without storage optimization feature I can see that dmc creates all tables with compress yes, adaptive is dmc repo considered as a production machine database is it allowed to have compressed table without optimization feature ? I presume in dev but ...

RE: db2 next

Posted By Guy Przytula Fri July 09, 2021 04:50 AM
Found In Egroup: Db2 \ view thread
thks I attended session 1 of webinar.. ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------

db2 next

Posted By Guy Przytula Thu July 08, 2021 03:15 AM
Found In Egroup: Db2 \ view thread
is there a kind of document, or other that describes the future of Db2 what can be expected ? what will be introduced ? a kind of roadmap ? ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------ #Db2

docker on windows

Posted By Guy Przytula Tue July 06, 2021 12:21 PM
Found In Egroup: Db2 \ view thread
I am not very familiar with docker installs I did the setup of docker in a vm, created a db.. all went ok a user is using docker on windows - no problems now he retrieved the docker container/image for db2 and tries to create a database this process is using 100% cpu and after 30min still hanging ...

dmc and memory

Posted By Guy Przytula Wed June 09, 2021 05:34 AM
Found In Egroup: Db2 \ view thread
as we get notifications in dmc about memory usage I had a look the screen indicates 25G of memory looking at top KiB Mem : 26568712 total, 504640 free, 4257068 used, 21807004 buff/cache KiB Swap: 8387580 total, 1744800 free, 6642780 used. 8545776 avail Mem we have 26G memory and 8G swap : total ...

RE: role granting

Posted By Guy Przytula Wed June 09, 2021 03:14 AM
Found In Egroup: Db2 \ view thread
thanks for the update - yes that will do ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------

role granting

Posted By Guy Przytula Tue June 08, 2021 04:20 AM
Found In Egroup: Db2 \ view thread
is there in db2 luw a view/tablefunction/sql that could list you all grants that have been given to a role or do you need to combine individual tables as sysibm.systabauth sysibm.sysroles and select granteetype='R' and join on roleid to find tablegrants and repeat this for other objects -------- ...

RE: dmc and fixcentral

Posted By Guy Przytula Tue May 25, 2021 04:07 AM
Found In Egroup: Db2 \ view thread
and the last remark : before you could filter on tags - is this not possible anymore ? ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------

RE: dmc and fixcentral

Posted By Guy Przytula Tue May 25, 2021 03:48 AM
Found In Egroup: Db2 \ view thread
dmc was not my friend but now he is being my enemy.. I had 12 connections defined : see connection profile screen when pressing database : short display of complete list - but replaced by only 2 connections .... ------------------------------ Thank for all update/help Best Regards, Guy ...

RE: dmc and fixcentral

Posted By Guy Przytula Tue May 25, 2021 03:28 AM
Found In Egroup: Db2 \ view thread
sorry : wrong screenshot - it is not possible to remove/replace the existing did edit and inserted new screenshot.. ------------------------------ Thank for all update/help Best Regards, Guy Przytula ------------------------------

RE: dmc and fixcentral

Posted By Guy Przytula Tue May 25, 2021 03:22 AM
Found In Egroup: Db2 \ view thread
now installed new fix as described and run setup new version applied and starting .... but after 7 minutes.. still no answer.. break it off - stop (because status indicates already started) start now immediately started and ready with new fix ------------------------------ Thank for all update/help ...