List of Contributions

KE CHEN

Contact Details

My Content

1 to 20 of 26 total

RE: DMC (3.1.9) Locking event montior - Empty ?

Posted By KE CHEN Wed November 23, 2022 08:45 PM
Found In Egroup: Db2 \ view thread
Hi Samuel, I can see the case. I will reply you in the case. Thanks. ------------------------------ KE CHEN ------------------------------

RE: DMC (3.1.9) Locking event montior - Empty ?

Posted By KE CHEN Wed November 23, 2022 02:00 AM
Found In Egroup: Db2 \ view thread
Hi Samuel, This is Ke from DMC development team. From the query result, console captured some locks for a connection with internal identifier 1. You need to check if that is the one named 'NoxGR' in your screen shot. Also note that, the timestamp in repo table is in UTC time. You can use this query ...

RE: Is db2 docker image for Apple M1 chip available?

Posted By KE CHEN Sun November 06, 2022 09:48 PM
Found In Egroup: Db2 \ view thread
Hi Jürgen, Thank you for the workaround link. It seems to work. 1. Before pull the image, run 'export DOCKER_DEFAULT_PLATFORM=linux/amd64' 2. Add '--platform=linux/amd64' parameter when issue 'docker run' command. ------------------------------ KE CHEN ------------------------------

Is db2 docker image for Apple M1 chip available?

Posted By KE CHEN Thu November 03, 2022 03:48 AM
Found In Egroup: Db2 \ view thread
Hi there, I want to install db2 docker version on my laptop. But I realize that I can not pull a compatible image. Could you advise how can I proceed? Thanks. no matching manifest for linux/arm64/v8 in the manifest list entries ------------------------------ KE CHEN ------------------------------ ...

RE: Table Function SYSPROC.SNAP_GET_UTIL_PROGRESS Fails With Termination Error

Posted By KE CHEN Thu April 08, 2021 09:33 AM
Found In Egroup: Db2 \ view thread
Hello Matthias, I can not view my private reply to you. Please let me konw if you can not see my message and email. Thanks, Equal ------------------------------ KE CHEN ------------------------------

RE: Table Function SYSPROC.SNAP_GET_UTIL_PROGRESS Fails With Termination Error

Posted By KE CHEN Thu April 08, 2021 09:33 AM
Found In Egroup: Db2 \ view thread
Hello Matthias, Thank you for contacting us for this problem. We need logs of the console to investigate how the error was triggered. You can follow this doc of step 2 to collect logs https://www.ibm.com/support/knowledgecenter/SS5Q8A_3.1.x/com.ibm.datatools.dsweb.ots.troubleshooting.doc/topics/t ...

RE: Blocking and waiting connections not shown

Posted By KE CHEN Tue June 16, 2020 10:40 PM
Found In Egroup: Db2 \ view thread
Hello Dirk, The known issue Jason mentioned is for historical view. But I notice that you're viewing the current records. Could you please view the 'Find locked objects' page and do show 'lock status' column(it's hidden as default)? The blocking and waiting records come from the source of 'Find ...

RE: JDBC Connection error in monitor.0 log files

Posted By KE CHEN Sun June 14, 2020 11:16 PM
Found In Egroup: Db2 \ view thread
Hello Javier, Thank you for letting us know this problem. This issue is also catched in house. And it's fixed in the coming release. Thanks, Ke ------------------------------ KE CHEN ------------------------------

RE: Exception errors in ibm_rtmon_data.STOREDPROCEDURE in monitor.0

Posted By KE CHEN Sun June 14, 2020 11:15 PM
Found In Egroup: Db2 \ view thread
Hello Javier, Thank you for letting us know this problem. This issue is also catched in house. And it's fixed in the coming release. Thanks, Ke ------------------------------ KE CHEN ------------------------------

RE: JDBC Connection error in monitor.0 log files

Posted By KE CHEN Thu May 28, 2020 01:43 AM
Found In Egroup: Db2 \ view thread
Hi Roland, This error is caused by absence of storage group. What's your consideration of not creating a storage group? Could you create one? We have made changes to avoid this exception upon this issue(in the coming release). But without storage group, you won't be able to view the storage usage ...

RE: Data about monitoring not send to repositary table

Posted By KE CHEN Wed May 20, 2020 03:35 AM
Found In Egroup: Db2 \ view thread
Hi Juraj, I'm sorry that we were not able to help you. But we're willing to find the cause and resolve it. Were the connections migrated from DSM or newly added in DMC? What are the versions of those database? Thanks, Ke ------------------------------ KE CHEN ----------------------- ...

RE: Data about monitoring not send to repositary table

Posted By KE CHEN Mon May 18, 2020 01:25 AM
Found In Egroup: Db2 \ view thread
Hi there, This is Ke from DMC team. I'd like to know more information about the problem you met. Do you have other dbs being monitored in the same monitor profile and have the same problem? Is the database active in the Home page? If you go to the summary page of the database, can you see collected ...

RE: All are equal -- but one

Posted By KE CHEN Thu May 14, 2020 03:59 AM
Found In Egroup: Db2 \ view thread
Hi, It seems that there is something wrong with that database. Did you view the summary page of that database and is everything right there? Best Regards, Ke ------------------------------ KE CHEN ------------------------------

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Wed April 29, 2020 05:25 AM
Found In Egroup: Db2 \ view thread
Hi, You are right. We have made changes to avoid this exception upon this issue. But without storage group, you won't be able to view the storage usage in the monitor summary page. Thank you for reporting this issue. Regards, Ke ------------------------------ KE CHEN --------------- ...

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Wed April 29, 2020 02:47 AM
Found In Egroup: Db2 \ view thread
I think you made a typo here. Those tables are created by event monitors in the monitored database. ACTIVITY IBM_RTMON T 2020-04-09-15.05.53.227220 ACTIVITY_STMT IBM_RTMON T 2020-04-09-15.05.53.568396 HISTOGRAMBIN IBM_RTMON T 2020-04-08-10.14.58.881885 LOCK_EVENT IBM_RTMON T 2020-04-08-10.14.54.443711 ...

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Wed April 29, 2020 02:33 AM
Found In Egroup: Db2 \ view thread
Hi Karsten Wilhelm, Thank you for your quick response. We have investigated this problem and found that it's caused by absence of storage group. What's your consideration of not creating a storage group? Could you create one? Thanks, Ke ------------------------------ KE CHEN --------- ...

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Mon April 27, 2020 10:32 PM
Found In Egroup: Db2 \ view thread
The schema name is a parameter to be passed in. It seems that there is something wrong with the data source from the previous query. It may return something that we didn't expect. So all the parameters are not correctly set. Could you run this query against connection named 'l16int21' and let us know ...

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Fri April 24, 2020 05:25 AM
Found In Egroup: Db2 \ view thread
Thank you for your reply. The error is saying that the first parameter can not to be null. It's not a normal behavior. We need the whole log file to investigate why the parameter is null. I will send you my email privately, could you send the log file to me? From the log, this line is ignored. ...

RE: ibm_rtmon_data exceptions

Posted By KE CHEN Fri April 24, 2020 12:06 AM
Found In Egroup: Db2 \ view thread
Hi Karsten, This is Ke from DMC development team. It's a problem to use the deprecated schema. Could you share the error messages in the log? Any other tables have the same problem? Does your repository database regard a line starts with -- as comment in a query? Thanks, Ke ----------- ...

RE: monitor element

Posted By KE CHEN Wed April 15, 2020 12:19 AM
Found In Egroup: Db2 \ view thread
Hi Guy, This column will be hided as default. But as you know, it will be used for Db2 new versions. So we will keep this column. ------------------------------ KE CHEN ------------------------------