I need to enable the COLUMNAR setting in DB2 Express Edition on Docker. For that to work I need to set INTRA_PARALLEL ON at the instance or database level.
I connect to the
db2 command with
db2inst1 that is the instance owner, but I’m getting an error saying that the user is root. How to fix this problem?
db2 => connect to bank0002 user db2inst1 using xxxxx Database Connection Information Database server = DB2/LINUXX8664 220.127.116.11 SQL authorization ID = DB2INST1 Local database alias = BANK0002 db2 => UPDATE DBM CFG USING INTRA_PARALLEL ON SQL5001N "ROOT" does not have the authority to change the database manager configuration file.