List of Contributions

Guy Przytula

Contact Details

My Content

1 to 20 of 50+ total

cdc and show events

Posted By Guy Przytula Tue February 13, 2024 05:39 AM
Found In Egroup: Db2 \ view thread
in this forum because no specific forum for cdc if executing the command show events - where is this info coming from ? is there a file or internal table that keeps this info ? the trace_dmts...log file does not keep the same info. it is always easier to collect info from a file than using the limited ...

RE: LOAD command fails

Posted By Guy Przytula Thu February 01, 2024 03:00 AM
Found In Egroup: Db2 \ view thread
as we see : db2 command prompt on luw the load syntax seems to be different from load on db2 luw : LOAD command in luw we only have load from del (csv file) or ixf or you have to use import and specifying layout even if target is db2:z you need to use luw syntax. ------------------------------ ...

RE: port and hadr

Posted By Guy Przytula Wed January 10, 2024 04:19 AM
Found In Egroup: Db2 \ view thread
yes of course.. but it would be nice to know the reason, if it would ever happen again at same or different customer ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------

RE: port and hadr

Posted By Guy Przytula Wed January 10, 2024 03:28 AM
Found In Egroup: Db2 \ view thread
no problem, any answer is welcome I also tried hadr simulator and we get msg : no route to host, although we can ping both servers I informed system people about it, they say : we did not change anything.. but now the problem is resolved. I do not know the cause now also started hadr and ...

RE: port and hadr

Posted By Guy Przytula Tue December 19, 2023 04:03 AM
Found In Egroup: Db2 \ view thread
i do not see why adding an additional translation, by using /etc/services instead of hardcoded hadr svc would resolve the problem I anyhow tested it and the problem remains the same as expected ------------------------------ Thanks for all answers Best Regards, Guy Przytula ----------- ...

RE: port and hadr

Posted By Guy Przytula Tue December 19, 2023 02:27 AM
Found In Egroup: Db2 \ view thread
thanks for the comment but the problem has nothing todo with db2 cfg/setup. this was done correctly db2 is complaining about O/S error and get socket.... as the system person does not know what is wrong, I posted this question. maybe someone has seen this before and a hint could help to ...

port and hadr

Posted By Guy Przytula Fri December 15, 2023 02:00 AM
Found In Egroup: Db2 \ view thread
using db2 and hadr on linux 11.5.5 db2 cfg has been set for hadr : local svc 50100 when starting hadr as standby we get 2023-12-15-07.33.37.569638+060 E21815023E616 LEVEL: Error (OS) PID : 10565 TID : 140583356065536 PROC : db2sysc 0 INSTANCE: dbadma NODE : 000 DB : ACC1 HOSTNAME: ...

xml indexes

Posted By Guy Przytula Wed December 06, 2023 04:06 AM
Found In Egroup: Db2 \ view thread
we have tables with xml columns I can see some indexes on these columns and as lastused=0001-01-01 and they use a lot of space i wanted to see the indexes, but they are not in the db2look output is there a table/view/any other where we can see the syntax/structure of this index ? ...

hadr settings

Posted By Guy Przytula Tue November 28, 2023 07:41 AM
Found In Egroup: Db2 \ view thread
when using db2 and hadr you need to specify local_svc and remote svc in db cfg when specifying in the db cfg a name, a lookup/translate is done by /etc/services the question is : does db2 do a remote lookup to translate remote_svc setting or can this also be specified in the local machine and ...

RE: db2 upgrade and cdc

Posted By Guy Przytula Tue July 18, 2023 10:01 AM
Found In Egroup: Db2 \ view thread
and which path do you mean ? we are upgrading db2 from 11.1 to 11.5 ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------

db2 upgrade and cdc

Posted By Guy Przytula Sun July 09, 2023 02:58 AM
Found In Egroup: Db2 \ view thread
there used to be a group for CDC, but I can not find it anymore as I read well, when upgrading db2 as target source, you need to mark all tables for capture point but what todo in this scenario : the target db2 is being migrated. in the meantime, the source db is being used after the ...

cdc and db2 migration

Posted By Guy Przytula Sun July 09, 2023 02:56 AM
Found In Egroup: Data Integration \ view thread
there used to be a group for CDC, but I can not find it anymore as I read well, when upgrading db2 as target source, you need to mark all tables for capture point but what todo in this scenario : the target db2 is being migrated. in the meantime, the source db is being used after the ...

RE: takeover connection

Posted By Guy Przytula Mon May 08, 2023 09:20 AM
Found In Egroup: Db2 \ view thread
thanks I will open a case after re-integration of server (that had vip) the vip was moved to other server but was unavailable when server was down ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------

RE: takeover connection

Posted By Guy Przytula Mon May 08, 2023 08:10 AM
Found In Egroup: Db2 \ view thread
thanks for the update I did not define the ACR - so now it has been done But a new situation occurs If standby leaves (network broken) no impact - all ok after integration BUT : if primary (server2) leaves (network broken) : database is moved - VIP is not moved and not available [root@server01 ...

takeover connection

Posted By Guy Przytula Sun May 07, 2023 06:39 AM
Found In Egroup: Db2 \ view thread
when using ACR and being connected to database when takeover occurs - the first dml gets rc if you repeat the dml without connect you get the answer when vip is defined and being connected to database when takeover occurs - the first dml gets rc if you repeat the dml without connect you get message ...

pacemaker vip

Posted By Guy Przytula Wed May 03, 2023 06:56 AM
Found In Egroup: Db2 \ view thread
pacemaker was setup on db2 linux 11.5.8 now trying to add the vip and according the doc [root@pacemkrp ~]# /home/db2ins11/sqllib/adm/db2cm -create -primaryVIP 192.168.44.129 -db QUERYDB -instance db2ins11 this command is accepted - does not return/ends and no error presented looking at second ...

RE: db cfg changes

Posted By Guy Przytula Wed May 03, 2023 02:32 AM
Found In Egroup: Db2 \ view thread
thanks for the update I created a sample db and compared with diff the current db cfg Many thanks.. -- Best Regards, ????????Beste Groeten, ???????? Meilleures Salutations Guy Przytula ?? Tel. GSM??: +32 (0)475-33.81.86 Email : Guy Przytula

db cfg changes

Posted By Guy Przytula Tue May 02, 2023 09:17 AM
Found In Egroup: Db2 \ view thread
db2 11.5.7 on redhat is there a command - tool that could show the dbcfg settings that are not the default so we can see what has changed ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------

RE: Db2 - NFS connection transfer archive logs error

Posted By Guy Przytula Fri March 24, 2023 05:58 AM
Found In Egroup: Db2 \ view thread
we had a similar problem on linux and had to add something to /etc/fstab mount setting https://www.ibm.com/support/pages/db2-backup-log-archive-nfs-mounted-drive-returns-dia8519c Consult with a System Administrator, to ensure the NFS directory is mounted with the "nolock" option. ...

RE: Db2 - NFS connection transfer archive logs error

Posted By Guy Przytula Fri March 24, 2023 04:23 AM
Found In Egroup: Db2 \ view thread
maybe this can help https://www.mail-archive.com/sam-qfs-discuss@opensolaris.org/msg00190.html ------------------------------ Thanks for all answers Best Regards, Guy Przytula ------------------------------