DB2 EXPRESS

I'm running DB2 Express v.10.5 on Win2012R2. All I need is to punch in a few CSVs to the tables I want to create. I get error while trying to rename an existing table or create a new Schema in DbVisualizer Pro. error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;a test authorization;, DRIVER=4.18.60 In Authorization Name I put DB2 admin name, which I created in DB2 installation wizard. Any help would be deeply appreciated!

Hi Dmytro, Is the Database Type for the connection set to either Auto Detect or DB LUW? If it is and you still get this, please open Tools->Debug Window and enable debugging for DbVisualizer. Then perform this operation again and include the debug output in your reply. Best Regards, Hans

Hans, thanks so much for the attention to my post - I set the DB to LUW and still error, while creating a new scheme: 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 F.?] Lease unused connection: unnamed2 - New Name: unnamed3 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 B.execute] Execute Command: db2-schemas-create SQL: create schema ${schemaName} authorization ${osUserid} 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 J.execute] Executing... 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 J.setCurrentCatalog] DbConnection='DB2' Catalog='null' Schema='null' NewCatalog='null' 11:29:15 [DEBUG pool-5-thread-1 C.?] unnamed3: b.createStatement() 11:29:15 [DEBUG pool-5-thread-1 B.?] unnamed3: po.execute("create schema test authorization ") 11:29:15 [DEBUG pool-5-thread-1 B.?] unnamed3: EXCEPTION -> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;a test authorization;, DRIVER=4.15.82 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;a test authorization;, DRIVER=4.15.82 at com.ibm.db2.jcc.am.fd.a(fd.java:696) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127) at com.ibm.db2.jcc.am.po.c(po.java:2761) at com.ibm.db2.jcc.am.po.d(po.java:2749) at com.ibm.db2.jcc.am.po.b(po.java:2116) at com.ibm.db2.jcc.t4.ab.i(ab.java:225) at com.ibm.db2.jcc.t4.ab.c(ab.java:48) at com.ibm.db2.jcc.t4.p.b(p.java:38) at com.ibm.db2.jcc.t4.qb.h(qb.java:114) at com.ibm.db2.jcc.am.po.hb(po.java:2111) at com.ibm.db2.jcc.am.po.a(po.java:3284) at com.ibm.db2.jcc.am.po.e(po.java:1091) at com.ibm.db2.jcc.am.po.execute(po.java:1070) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.B.?(Z:104) at com.onseven.dbvis.g.B.F$A.call(Z:1474) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 AbstractFacade.getColumn] executing "select current schema from sysibm.sysdummy1" 11:29:15 [DEBUG pool-5-thread-1 C.?] unnamed3: b.createStatement() 11:29:15 [DEBUG pool-5-thread-1 B.?] unnamed3: po.executeQuery("select current schema from sysibm.sysdummy1") 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 F.?] Freeing connection: unnamed3 for DB2 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 B.execute] Execute Command: getSchemaNames 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 N.?] DbConnection: DB2 11:29:15 [DEBUG pool-5-thread-1 E.?] RootConnection: e.getSchemas() 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 AbstractFacade.getColumn] executing "select current schema from sysibm.sysdummy1" 11:29:15 [DEBUG pool-5-thread-1 C.?] RootConnection: b.createStatement() 11:29:15 [DEBUG pool-5-thread-1 B.?] RootConnection: po.executeQuery("select current schema from sysibm.sysdummy1") 11:29:15 [DEBUG ExecutorRunner-pool-4-thread-2 B.execute] Total rows/columns: 13/2. Rows after filtering: 13

All is OK now, I created a new DB with db2admin user and than imported in my CSVs. Cheers,

Hi Dmytro, I'm glad to hear you found a solution. In the debug log you sent, it looks like the main problem was that you had not enter an Owner in the Create Schema dialog and instead left the placeholder value "". Best Regards, Hans