Start a new topic

DB2 EXPRESS

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

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!

[This reply is migrated from our old forums.]

Re: DB2 EXPRESS
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
[This reply is migrated from our old forums. The original author name has been removed]

Re: DB2 EXPRESS
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
[This reply is migrated from our old forums. The original author name has been removed]

Re: DB2 EXPRESS
All is OK now, I created a new DB with db2admin user and than imported in my CSVs. Cheers,
[This reply is migrated from our old forums.]

Re: DB2 EXPRESS
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