The Stack Overflow podcast is back! Listen to an interview with our new CEO.

New answers tagged

2

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0021804.html User authentication is completed by a security facility outside the Db2 database system, through an authentication security plug-in module. A default authentication security plug-in module that relies on operating-system-based authentication is ...


1

If it's not some educational task or quiz with trigger use in Db2, then it's better to use Row and column access control (RCAC) for such a goal.


0

The list applications command requires an instance attachment, which is performed implicitly when you first run this command against "instance1". The CLP back-end process db2bp, which handles all server commands and SQL statements on behalf of the front-end program CLP db2, remains attached to the "old" instance after you switch the environment. You need ...


0

As long as there is no application code that uses the partitioning scheme in their logic, adding a partition is a solution to your space issue. I would suggest that you use 5 partitions instead of 4. Your data should then spread out more evenly. P1 00-20 P2 21-40 ...


-1

It is not possible to directly rename the db2 instance name, But following steps can be used to move the db to new instance Take the backup of DB's and provide 755 permissions to backup images. Offline backup is recommended db2stop command to stop the instance drop current instance name by using db2idrop command create new instance by using db2icrt ...


0

The Db2 function to obtain the most recent assigned identity value is IDENTITY_VAL_LOCAL().


-1

You may want to create a new instance with instance name as dbroot and then move all your database to new instance dbroot (from current instance db2inst1) using db2relocatedb utility. Please check: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0004500.html


0

You may even shorten the last solution via XMLTABLE() by getting rid of the value tag: SELECT sd.ID, sd.OtherId, si.item as NewId from session.sample_data sd ,XMLTABLE('$doc/items/item' PASSING XMLPARSE(DOCUMENT CAST( '<items><item>' || replace(sd.Data , ',' , '</item><item&...


1

You need two joins here, one with the "matching" type set, another with "default" type. I'm making two assumptions: "Missing" p_type is an empty string, not null, as follows from your query. There is at most one row in t_price for each p_route and empty p_type. : select r_route, r_type, coalesce(match.p_price, dflt.p_price) from t_route left outer join ...


1

An error like this might be returned if you will try to connect to a port which is actually not the port DB2 server listens on. E.g. if I would, by mistake, try to connect to port 22 (ssh) I will get the same error: $ java com.ibm.db2.jcc.DB2Jcc -url jdbc:db2://localhost:22/SAMPLE -user db2v111 -password passw0rd [jcc][10521][13706]Command : java com.ibm....


Top 50 recent answers are included