I’m having trouble setting up DB2 on macOS via Docker on my M1-Max MacBook Pro (32 GB RAM). I already had a look at this question, which might be related, however there is not a lot of information and I cannot exactly say, if it is about the exact same thing. I set up following docker-compose.yml: versi…
Tag: db2
CLPPLUS login failing
I am trying to login to remote DB2 using clpplus but can’t login as password contains @. clpplus -nw user/p@sswd@145.xx.xx.212:60000/Dbname but it fails saying: Is there any work around of it? Answer With the bash shell, enclose the password with ‘ and additionally escape the @ with @ (and the sam…
DB2 Create Database takes long time
I’m new to Db2 and just installed v11.5 on my Ubuntu 18.04. I referred these two links for setup purpose: IBM and DCON I’m using DB2 CLI to create a database. On typing in create database <database_name> and press enter, it just stays there; there’s no output. I checked the db2diag.log…
How to block a user from executing select queries on a table in Db2?
I have a database ‘SAMPLE’ in which I need to block a user ‘DB2ADMIN’ from executing I already tried I get error SQL0556N and message “DB2ADMIN does not hold this privilege”, which means it shouldn’t have worked in first place. Still I am able to get select query resu…
Connect Python to Remote DB2 Server
Using Python’s DB2 API, ibm_db, I am attempting to connect to a remote DB2 server (at IP address 10.0.0.001 which I can successfully ssh into). Both client and server machines are Linux / Ubuntu 16.0 LTS. In all my attempts and solutions, I continually run into the regular SQL1639N error. Python 3.5 (at…
‘pecl install ibm_db2’ can’t find library
I’m trying to install ibm_db2 through pecl: Then when it asks for an install dir, I have tried various places only to have the same result. It goes through a bunch of checks etc., then tries to ‘make’ and gets an error: It always looks there for the libraries. And they exist, because when I …