SupportSupport

Oki, I switched to DB2 z/OS and then the alter table feature disappeared so I guess the problem is solved....

BTJ

DB2 AS/400?

Roger

This is when using DB2 z/OS and enabling only defaul schema yes....

BTJ

Roger,

thanks for the fix, users and roles are working now.

@ Hans:
Here's the complete debugging output.

Thanks guys for working on those bugs. DBVis is getting pretty usable with Informix 9.xx 

(not to mention that there isn't much else on the market to compete price)

So thanks again,
Dirk
------------------------------------------------------------
16:42:03 \[DEBUG AWT-EventQueue-1 L.execute] Executing...
16:42:03 \[DEBUG AWT-EventQueue-1 L.prepareStatement] SQL: SELECT
    *
FROM
    informix.systables
WHERE
    tabtype   = 'T'
    and tabid > 99
    and owner like 'informix'
    and tabname like 'map_server_dienste'
ORDER BY
    tabname
16:42:03 \[DEBUG AWT-EventQueue-1 L.prepareStatement] nativeSQL from driver: SELECT
    *
FROM
    informix.systables
WHERE
    tabtype   = 'T'
    and tabid > 99
    and owner like 'informix'
    and tabname like 'map_server_dienste'
ORDER BY
    tabname
16:42:03 \[DEBUG AWT-EventQueue-1 B.execute] Total rows/columns: 1/20. Rows after filtering: 1
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     owner,     tabname FROM     informix.systables WHERE     tabname   = ?    AND owner = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     owner,     tabname FROM     informix.systables WHERE     tabname   = ?    AND owner = ?
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname,     c.coltype,     c.collength,     d.default,     c.colno FROM     informix.systables t,     informix.syscolumns c,     OUTER(informix.sysdefaults d) WHERE     t.tabid       = c.tabid     AND c.tabid   = d.tabid     AND c.colno   = d.colno     AND t.tabname = ?    and t.owner   = ?ORDER BY     c.colno
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname,     c.coltype,     c.collength,     d.default,     c.colno FROM     informix.systables t,     informix.syscolumns c,     OUTER(informix.sysdefaults d) WHERE     t.tabid       = c.tabid     AND c.tabid   = d.tabid     AND c.colno   = d.colno     AND t.tabname = ?    and t.owner   = ?ORDER BY     c.colno
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrtype    = 'P'     AND t.tabname = ?    and t.owner   = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrtype    = 'P'     AND t.tabname = ?    and t.owner   = ?
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[3] name=\[colId] value=[1] type=\[Integer] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[3] name=\[colId] value=[2] type=\[Integer] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[name] value=\[map_server_dienste] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[schema] value=\[informix] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16,     r.ptabid,     r.primary,     r.delrule FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c,     informix.sysreferences r WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrid   = r.constrid     AND c.constrtype = 'R'     AND t.tabname    = ?    AND t.owner = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16,     r.ptabid,     r.primary,     r.delrule FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c,     informix.sysreferences r WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrid   = r.constrid     AND c.constrtype = 'R'     AND t.tabname    = ?    AND t.owner = ?
16:42:05 \[DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 \[DEBUG Thread-21 L.execute] Executing...
16:42:05 \[DEBUG Thread-21 O.?] index=[1] name=\[tableId] value=\[100] type=\[Long] options=[]
16:42:05 \[DEBUG Thread-21 O.?] index=[2] name=\[name] value=\[100_7] type=\[String] options=[]
16:42:05 \[DEBUG Thread-21 L.prepareStatement] SQL: SELECT     t.owner,     t.tabname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i WHERE     t.tabid             = i.tabid     AND t.tabid         = ?    AND trim(i.idxname) = ?
16:42:05 \[DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     t.owner,     t.tabname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i WHERE     t.tabid             = i.tabid     AND t.tabid         = ?    AND trim(i.idxname) = ?
e = java.lang.NullPointerException
java.lang.NullPointerException
    at com.onseven.dbvis.R.A.D.?(Unknown Source)
    at com.onseven.dbvis.R.A.D.?(Unknown Source)
    at com.onseven.dbvis.a.F.B.F.?(Unknown Source)
    at com.onseven.dbvis.a.B.A.B$A.execute(Unknown Source)
    at com.onseven.dbvis.F.B.H.construct(Unknown Source)
    at se.pureit.swing.util.SwingWorker$2.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Dirk,

One more things. Can you please run this query as well:

SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = <tabId>

where <tabId> is the "r.tabid" value from the query I asked you to run earlier.

Thanks,
Hans

... and here's the rest. Thanks for looking into that!

Greets
Dirk
--------------------------------------------
08:23:31 \[DEBUG Thread-16 L.prepareStatement] SQL: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 100
08:23:31 \[DEBUG Thread-16 L.prepareStatement] nativeSQL from driver: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 100
08:23:31 \[DEBUG AWT-EventQueue-1 H.?] Edit not allowed: More then one table is referenced in the FROM clause
08:23:41 \[DEBUG Thread-17 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
08:23:41 \[DEBUG Thread-17 L.execute] Executing...
08:23:41 \[DEBUG Thread-17 L.prepareStatement] SQL: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 103
08:23:41 \[DEBUG Thread-17 L.prepareStatement] nativeSQL from driver: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 103
08:23:41 \[DEBUG AWT-EventQueue-1 H.?] Edit not allowed: More then one table is referenced in the FROM clause

Ronald,

We did a few changes in 5.1.1.9 to hopefully fix this. Does this happen with other OSes as well?

What do you mean with "last updates"? Drivers, bookmarks and other settings or changes in the actual database? If you mean changes in terms of application settings then these are stored not only at a clean exit but also during some activities in DbVisualizer.

Regards

Roger

Thanks Dirk,

I need the value of one more column, so can you please run this query for one of the "r.tabid" values from the previous query?

SELECT t.owner, t.tabname, i.idxname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = <tabId>

Regards,
Hans