List of Contributions

RE: DB2 Documentation 11.5 very slow

Posted By Andres Gomez Casanova Tue May 11, 2021 09:00 PM
Found In Egroup: Db2 \ view thread

Hi, I completely agree with the documentation performance. Also, it requires Internet access and in the hypothetical case of a Disaster recovery Internet access could not available. Also, I would like something running in a docker, easier to deploy. ------------------------------ Andres Gomez ...

RE: Some shorcuts are wrong in dmctop - help

Posted By Andres Gomez Casanova Thu July 23, 2020 12:29 PM
Found In Egroup: Db2 \ view thread

Hi, I have found very useful to move in the detail window with the same keys as vi (Up j, Down k, Left h and Right l), however, these keys are also mapped for some options in the menu: l is connections h is help This creates a collision in the shortcuts. ------------------------------ ...

dmctop always shows port 50000

Posted By Andres Gomez Casanova Thu July 23, 2020 09:52 AM
Found In Egroup: Db2 \ view thread

When I save the properties of dmctop, it always shows port 50000 in different instance with different port number. For example, in the attached image, the properties are for a local connection within an instance that has a different port from 50000, but the message shows 50000. ------------- ...

Some shorcuts are wrong in dmctop - help

Posted By Andres Gomez Casanova Fri July 17, 2020 11:05 PM
Found In Egroup: Db2 \ view thread

Hi, While reviewing the new application, the dmctop, I found the following incoherences / bugs in the help > shorcut window and the application. The shorcut is different, and the help menu is wrong. ------------------------------ Andres Gomez Casanova IBM Champion 2015-2020 DBA senior ...

Security processing failed with reason "15" ("PROCESSING FAILURE")

Posted By Andres Gomez Casanova Thu June 04, 2020 04:15 PM
Found In Egroup: Db2 \ view thread

Hi, I have configured correctly my databases in the console, and I am currently viewing information in the different graphs. However, when looking at the different logs, I got this: monitor (276) Jun 4, 2020 1:51:01 PM ERROR onefraud-Desarrollo_276:exc = ### Error querying database. Cause: co ...

Initialize profile for imported configuration

Posted By Andres Gomez Casanova Tue June 02, 2020 05:33 PM
Found In Egroup: Db2 \ view thread

I have imported a set of database into the Data Management Console, but for the new ones I got this: The current profile is not initialized, please double check all the required fields, save it and try again. I have to click in the properties for each one, in order to activate it for monitoring. ...

Error message incorrect while configuring repository

Posted By Andres Gomez Casanova Mon June 01, 2020 01:26 PM
Found In Egroup: Db2 \ view thread

When configuring the first time the repository, when using a generic user, it says: Error: "MYUSER" does not have the privilege to perform operation "CREATE BUFFERPOOL".. SQLCODE=-552, SQLSTATE=42502, DRIVER=4.26.14 For a Db2 repository database, the user must have DBADM or SYSCTRL privilege. ...

Support for Solaris as Db2 client in 11.5?

Posted By Andres Gomez Casanova Tue May 05, 2020 04:45 PM
Found In Egroup: Db2 \ view thread

Hi community, I know IBM dropped support for Db2 in Solaris in V11.5, and I could understand that fact for database server. However, Solaris machines are not only used for database servers, they are also used for clients. Our company uses Solaris for its core, and they have no plans to change it. ...

Different date subtraction between 10.5 and 11.5

Posted By Andres Gomez Casanova Tue May 05, 2020 04:29 PM
Found In Egroup: Db2 \ view thread

Hi community, I am facing this issue, but I am not sure if this is right or did I miss to set something. I am just simply performing a date subtraction without specifying the type (day, hour, minute), and I got the following (I executed on 2020-05-04): v11.5 - db2 supposes it is a day [db2inst1@db2v115 ...

RE: Problem to access a databases after migration to 11.5

Posted By Andres Gomez Casanova Thu March 19, 2020 05:00 PM
Found In Egroup: Db2 \ view thread

Hi, Well, as you said Harish and SangGyu, I had to contact the IBM support and the problem was solved. They gave me a new set of SPCS files, I just replaced them and the database was online again. The source of the problem was that when I performed the db2 upgrade command, there was at the same ...

Problem to access a databases after migration to 11.5

Posted By Andres Gomez Casanova Mon March 16, 2020 04:25 PM
Found In Egroup: Db2 \ view thread

Hi, I migrated to 11.5, but when I connect to the databases, it says: $ db2 connect to MYDB SQL5035N The connection failed because the database product has been updated and the database needs to be upgraded SQLSTATE=55001 When I perform the upgrade: $ db2 upgrade db MYDB SQL1704N Database ...

Andres Gomez Casanova, AngocA

Contact Details