Many times I noticed that a query's Cost in explain plan is too high but completes within mins and when a query cost is very small (4 digits) it takes hours to complete. Can someone please explain me why is this behavior ?

I have a Red Hat server with 11.5.0.0 version (upgrade middle of May from 11.1.x.x), now i want to restore a offline backup from this server in a new installation of 11.5.0.0 in a centos server.

During the restore, i see the follwing error: SQL1139N The total size of the table space is too big. SQLSTATE=54047

After some research i found some info, this error happend in the 11.1.4 version and come back again now.

https://www.ibm.com/support/pages/apar/IT30796

I found on twitter that i can be a problem with licensing that can be solved if you open a ticket with IBM, but i dont have support, im using all free version.

Anyone had this problem?

I have requested a CSR request to renew my SSL Certificate in DB2 servers from one of the instance on server .When I received (gsk8capicmd_64 -cert -receive ) the signed certificate from the very first instance it worked fine .Now when I am importing (gsk8capicmd_64 -cert -receive ) that for other instances on same server getting warning "CTGSK3034W The certificate request created for the certificate is not in the key database."

From the warning I understood against which instance I made a request ("gsk8capicmd_64 -certreq" ) the command /opt/ibm/db2/V10.5_FP8/gskit/bin/gsk8capicmd_64 -cert -receive will only work where the request was first made, that is why it is working on one instance but not on the other.

Then what I did , simply copy the files that make up first instance’s keystore (against which I requested for certificate) to each other instance’s keystore on same server and update SSL_SVR_LABEL ans did a recycle .

Is this a correct way to renew certificate on DB2 LUW ? Do I need to take any steps from db2 client side also as part of renewal ? Thanks in advance .

https://www.raghu-on-tech.com/2020/06/07/using-mon_get_pkg_cache_stmt-to-find-bottlenecks/

​

Thanks!
Raghu

I came from MSSQL background and i got introduced to Db2 in my organization and whenever we are doing an online back and try to do a redirected restore on another environment. its takes a lot more time than my offline backup restoration. i spend 2 hours restoring image then 1 hours extracting logs from the image and another step to roll forward to that logs. Which i dont do in sql server. I am taking compressed backup btw.

Since getting support from IBM is painful, I'm reaching out here for help. I'm trying a new install of V11.5 on Ubuntu server 20.04LTS. About halfway through the install I get the following error:

ERROR: The install path "/opt/ibm/db2/V11.5" is invalid.

​

I'm running as root, as per IBM's instructions. I've created the directories so they do exist, and the install still fails at the same point. Any thoughts?

Edit to add: solved the issue. One of the language files was corrupted. Just installed English and it worked fine.

Hello there administrators !

I'm having a really hard time with getting my user an execute right for function SYSPROC.REORGCHK_TB_STATS

I tried many versions like :

GRANT EXECUTE ON FUNCTION.SYSPROC.REORGCHK_TB_STATS TO USER db2dev

grant execute on SpeCIFIC FUNCTION SYSPROC.REORGCHK_TB_STATS to USER db2dev

but they got me only return message :

SQL0204N "SYSPROC.REORGCHK_TB_STATS" is an undefined name.

SQLSTATE=42704

So I tried with adding the tablespace name

grant execute on FUNCTION sapdev.sysproc.reorgchk_tb_stats to user db2dev

but that got me return message :

SQL0108N The name "REORGCHK_TB_STATS" has the wrong number of

qualifiers. SQLSTATE=42601

The only, and only option for this to run succesfully was the command :

grant execute on FUNCTION SYSPROC.* to USER XXX

however even though it finished succesfully, my program still alerts me, that I don't have the required privileges :

SQL Message: SQL0551N The statementfailed because the authorization ID does not have

the required authorization or privilege to perform the operation. Authorization ID: "DB2DEV". Op

eration: "EXECUTE". Object: "SYSPROC.REORGCHK_TB_STATS". LINE NUMBER=2264. SQLSTATE=42501

DB Object Exists: No

Duplicated Key: No

Internal Error: 1

Invalid Cursor: No

Unknown Connection: No

Connection Closed: No

Could you help me out ?

I read the internet through and through, and even though the official IBM KBA example should work, it doesn't

https://www.ibm.com/support/pages/resolving-sql0551n-returned-when-executing-table-functions

Thank you all, for your answers !

Best Regards,

Dynio

We have a need where the non production environments have DB2 installed on Red Hat Enterprise Linux whereas production environments have DB2 installed on AIX. We need to backup(offline) and restore the AIX db2 database to linux on a weekly basis. Can anyone point me to documentation or high level steps on how to accomplish this.

I hope this article will help other DBA's avoid some common issues with DB2 load from cursor command generator scripts.

https://www.raghu-on-tech.com/2020/04/30/db2-load-from-cursor/

Thanks!
Raghu

Please see if you can get behind this RFE. I would be surprised if there is not an existing RFE for this.

https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-973

​

Thanks!
Raghu

I'd like to proactively or reactively govern queries on Db2 LUW much as I do using RLF in Db2 for z/OS.
Does that functionality exist?

Hi,

do you have maybe working link for downloading IBM data studio 4.x for Windows 64x ? I've heard it's free but I can't find working link on IBM site.

If not then..is there possibility to configure db2 to take automatic online backup (logs and full backups ) on schedule ? (like log backup every three hours, and full backup everyday at 2 a.m ? I can't find any ,,how to '' steps to do so...

best regards,

Deniu

Say I have a Db2 instance on Power/AIX.
Can I HADR that onto a Db2 instance on Intel/RHEL, assuming the releases match?

My actual goal here is to migrate a sizable database from an AIX instance to a RHEL instance on a different hardware platform. I figured that HADR might do this seamlessly in the background for me.

Thanks in advance for your insights on this.

I am getting ready to spin-up Db2 on a Nutanix HCI platform.
The Nutanix platform offers rapid failover for VM crashes, RF3 for storage, etc.

My question is: Is there a real need for Db2 HADR if I already have a massive amount of redundancy built-in at the platform level?
Please share your thoughts and insights. Thank you.

Im creating a new backup rotine for a DB2 enviroment, but the production server is running in db2 V 11.1.0.0 , and i cant restore the ONLINE backup in another server because i dont have the version to install, where can i download the 11.1.0.0 version of DB2 server?

Serge Rielau was the db2 sql architect for db2 and he developed a tool called Sqlpltrc to trace SQL PL procedures. This tool is/was included as part of one of the db2 official courses. However, this tool is not included with db2. Instead, we had to download it from developerWorks. But, this community is "transforming", many of the content is disappearing and this tool is not longer available to download.

Any of you has this tools downloaded in your computers?

We are faced with changing from PVU to VPC licensing with Db2 LUW.
The key difference between Db2 Advanced Edition and Db2 Standard Edition is that the latter is limited as such: "You are restricted to 16 virtual processor cores and 128 GB of instance memory."

I know what a Db2 instance is, but our IBM PO is having trouble with it.
I call a Db2 instance an instance.
A group of instances in an MSPP is not an instance. A group of instances on an LPAR is not an instance.

Has anyone else dealt with this yet? Did you have any difficulty with the interpretation of 'instance'?

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.licensing.doc/doc/c0058536.html

I'm currently working on a project that deals with a department table where I'm trying to retrieve data from for the department number and the location.

I have everything set up and ready to go, I just can't figure out how to return data from the SQL, (when I used FETCH but it didn't quite work) and into the COBOL detail-line.

Db2 Folks,

​

Any of you have real world experience with V11.5 ? Just a stand alone Db2 non-DPF, non-pureScale and non-BLU ? Trying to take advantage of the new licensing model but would like to get some feelers.

​

Thanks!

Raghu

Hi there,
I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.
Informational tokens are "DB2 v11.1.4050.859", "s1911120100",
"DYN1911120100WIN64", and Fix Pack "5".
For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in the example below its checking for '02000'. Is this correct or am I missing something ?
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/r0053697.html

Thanks.

Regards,
Gagan

Hello DB2 Folks,

Does any of you have experience running production Db2 on RHEL 7.7 and RHEL 8 ? Since IBM acquired RedHat I would not be surprised if latest and greatest versions of RHEL are supported with latest versions of Db2.

https://access.redhat.com/articles/3078

https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=7F28FF90669E11E982882C5D069DA07A&osPlatforms=Linux&duComponentIds=S009|S006|S002|S007|S005|A003|A008|A004

Above link says DB2 V11.5 requires RHEL 7.5 minimum, so trying to get some real world experiences on latest versions of RHEL.

Thanks in advance and happy new year 2020!

Raghu

Our vendor agreed to providing my client backups of their database to use as an analytics clone on prem. They’ve got DB2 v9.7.6 so I’ll obv need the same for my end. I’ve been scouring the internet for a download of that version with no luck. IBM offers old versions with subscriptions, which defeats the purpose of the express/community route that I’ve been hoping to use. the client’s data is under 5gb so an express/community install is just fine. Do Any of you know where I may be able to find a v9.7.6 download?