Tables not showing in schema of DB2

Avatar
Carlosd Dev
Created

Hello, DataGrip is not showing the tables of my DB2/AS400 database schema 

 

I can connect to the DB and see the schema `BASXX80`which is the one I'm using but I can not see the tables, I can also query the tables of this schema using the console so I don´t know what is going on.

 

 

I'm using DataGrip 2019.3.2 and MacOS Catalina.

 

Logs:
2020-02-03 20:00:28,507 [3614812] INFO - ution.rmi.RemoteProcessSupport - /Applications/DataGrip.app/Contents/jbr/Contents/Home/bin/java -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/Applications/DataGrip.app/Contents/lib/util.jar:/Applications/DataGrip.app/Contents/lib/trove4j.jar:/Applications/DataGrip.app/Contents/lib/groovy-all-2.4.17.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Applications/DataGrip.app/Contents/plugins/DatabaseTools/lib/dekaf-single-2.0.0.390.jar:/Users/cddm/Library/Preferences/DataGrip2019.3/jdbc-drivers/JTOpen (DB2 iSeries)/9.4/jt400-9.4.jar" com.intellij.database.remote.RemoteJdbcServer com.ibm.as400.access.AS400JDBCDriver
2020-02-03 20:00:28,934 [3615239] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 5759/RemoteDriverImpl5cbc465e
2020-02-03 20:00:28,990 [3615295] INFO - .DatabaseConnectionEstablisher - Connecting as: INTRA
2020-02-03 20:00:28,991 [3615296] INFO - .DatabaseConnectionEstablisher - Connecting to: jdbc:as400://172.16.45.11:446/BASXX80
2020-02-03 20:00:30,135 [3616440] INFO - ution.rmi.RemoteProcessSupport - Driver: AS/400 Toolbox for Java JDBC Driver 11.4
2020-02-03 20:00:30,136 [3616441] INFO - ution.rmi.RemoteProcessSupport - getDatabaseProductName: DB2 UDB for AS/400
2020-02-03 20:00:30,136 [3616441] INFO - ution.rmi.RemoteProcessSupport - getDatabaseProductVersion: 06.01.0000 V6R1m0
2020-02-03 20:00:30,136 [3616441] INFO - ution.rmi.RemoteProcessSupport - Detected: DB2 06.01.0000
2020-02-03 20:00:30,136 [3616441] INFO - ution.rmi.RemoteProcessSupport -

Votes

0

Share

4 comments
Avatar
Yuriy Vinogradov
Created

Hello, could you please attach full IDE logs?

0
Avatar
fabio pellati
Created

I have a similar issue on a linux

I cannot refresh a  IBMdb2 schema details (tables ecc...) from a

iBMI5 series although I can take all schema from another one IbmI 7

 

Yuriy How can I get the full log?

0
Avatar
Yuriy Vinogradov
Created

It is Help -> Collect logs and diagnostic data menu. Also we will need database.log from Help -> Show SQL log.

0
Avatar
fabio pellati
Created 
database log:
set schema QSECOFR
-- ] --------------------------------------------------
-- 2020-06-11 14:37:28 [celemasche] [Generalcavi_10.10] [introspection] [session id: 33189532] [statement id: 660296488] error - [42505][-99999] Connection authorization failure occurred.
-- 2020-06-11 14:37:28 [celemasche] [Generalcavi_10.10] [introspection] [session id: 33189532] [statement id: 660296488] finished - execution time: 9 ms


diagnostic data
2020-06-11 14:37:27,525 [ 935541] INFO - ution.rmi.RemoteProcessSupport - /home/fabio/.local/share/JetBrains/Toolbox/apps/datagrip/ch-0/201.7846.70/jbr/bin/java -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/home/fabio/.local/share/JetBrains/Toolbox/apps/datagrip/ch-0/201.7846.70/lib/util.jar:/home/fabio/.local/share/JetBrains/Toolbox/apps/datagrip/ch-0/201.7846.70/lib/trove4j.jar:/home/fabio/.local/share/JetBrains/Toolbox/apps/datagrip/ch-0/201.7846.70/lib/groovy-all-2.4.17.jar:/home/fabio/.local/share/JetBrains/Toolbox/apps/datagrip/ch-0/201.7846.70/plugins/DatabaseTools/lib/jdbc-console.jar:/home/fabio/.config/JetBrains/DataGrip2020.1/jdbc-drivers/JTOpen (DB2 iSeries)/9.4/jt400-9.4.jar" com.intellij.database.remote.RemoteJdbcServer com.ibm.as400.access.AS400JDBCDriver 
2020-06-11 14:37:27,773 [ 935789] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 39954/RemoteDriverImpl7d9dc7b2 
2020-06-11 14:37:27,806 [ 935822] INFO - atabaseCredentialsAuthProvider - Connecting as: qsecofr 
2020-06-11 14:37:27,806 [ 935822] INFO - .DatabaseConnectionEstablisher - Connecting to: jdbc:as400://192.168.10.10 
2020-06-11 14:37:28,777 [ 936793] INFO - ution.rmi.RemoteProcessSupport - Driver: AS/400 Toolbox for Java JDBC Driver 11.4 
2020-06-11 14:37:28,780 [ 936796] INFO - ution.rmi.RemoteProcessSupport - getDatabaseProductName: DB2 UDB for AS/400 
2020-06-11 14:37:28,780 [ 936796] INFO - ution.rmi.RemoteProcessSupport - getDatabaseProductVersion: 05.04.0000 V5R4m0 
2020-06-11 14:37:28,780 [ 936796] INFO - ution.rmi.RemoteProcessSupport - Detected: DB2 05.04.0000 
2020-06-11 14:37:48,664 [ 956680] INFO - j.ide.actions.RevealFileAction - Timed out 
2020-06-11 14:37:48,664 [ 956680] INFO - j.ide.actions.RevealFileAction - kf5.kio.core: Refilling KProtocolInfoFactory cache in the hope to find "stash"
Trying to convert empty KLocalizedString to QString.
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/today")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/yesterday")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/thismonth")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/lastmonth")
org.kde.dolphin: Ignore KIO url: QUrl("search:/documents")
org.kde.dolphin: Ignore KIO url: QUrl("search:/images")
org.kde.dolphin: Ignore KIO url: QUrl("search:/audio")
org.kde.dolphin: Ignore KIO url: QUrl("search:/videos")
qt.accessibility.core: Cannot create accessible child interface for object: PlacesView(0x56286234a770) index: 22
kf5.kio.core: KLocalSocket(0x562861f7ce50) Jumbo packet of 70448 bytes
inotify_add_watch("/home/fabio/.dropbox/aggregation.dbx") failed: "No such file or directory"
QObject::connect: invalid null parameter
QObject::connect: invalid null parameter
QObject::connect: invalid null parameter
UdevQt: unhandled device action "move"

2020-06-11 14:40:12,533 [1100549] INFO - j.ide.actions.RevealFileAction - Timed out 
2020-06-11 14:40:12,533 [1100549] INFO - j.ide.actions.RevealFileAction - kf5.kio.core: Refilling KProtocolInfoFactory cache in the hope to find "stash"
Trying to convert empty KLocalizedString to QString.
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/today")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/yesterday")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/thismonth")
org.kde.dolphin: Ignore KIO url: QUrl("timeline:/lastmonth")
org.kde.dolphin: Ignore KIO url: QUrl("search:/documents")
org.kde.dolphin: Ignore KIO url: QUrl("search:/images")
org.kde.dolphin: Ignore KIO url: QUrl("search:/audio")
org.kde.dolphin: Ignore KIO url: QUrl("search:/videos")
qt.accessibility.core: Cannot create accessible child interface for object: PlacesView(0x55f6077259f0) index: 22
kf5.kio.core: KLocalSocket(0x55f60737a0e0) Jumbo packet of 70448 bytes
kf5.kio.core: We got some errors while running testparm "Load smb config files from /etc/samba/smb.conf\nLoaded services file OK.\nWARNING: The 'netbios name' is too long (max. 15 chars).\n\n"
inotify_add_watch("/tmp/systemd-private-13149207b72346c6bed960679971cb62-systemd-timesyncd.service-IXV2HH") failed: "Permission denied"
inotify_add_watch("/tmp/systemd-private-13149207b72346c6bed960679971cb62-systemd-resolved.service-qnfck7") failed: "Permission denied"
inotify_add_watch("/tmp/systemd-private-13149207b72346c6bed960679971cb62-rtkit-daemon.service-MIGMo6") failed: "Permission denied"
inotify_add_watch("/tmp/systemd-private-13149207b72346c6bed960679971cb62-ModemManager.service-AeWluy") failed: "Permission denied"
inotify_add_watch("/tmp/systemd-private-13149207b72346c6bed960679971cb62-colord.service-sAhAgY") failed: "Permission denied"
inotify_add_watch("/tmp/cvcd") failed: "Permission denied"
inotify_add_watch("/home/fabio/.dropbox/aggregation.dbx") failed: "No such file or directory"

2020-06-11 16:25:55,891 [7443907] INFO - ateSettings.impl.UpdateChecker - failed to load plugin descriptions from : Malformed URL:
0

Please sign in to leave a comment.