Hello,

Sorry for the frequent emails.

I finally got myself a greenscreen account on someones R&D system, and I'm
trying to put PASE through its paces. The macines doesn't have X11
forwarding

My favorite SQL GUI for DB2 is http://www.sql-workbench.net/. It also has a
console java app. I sftped the files to the system and ran the command and
got this error:

bash-4.2$ ./sqlwbconsole.sh
/bin/java[13]: /QSYS.LIB/QJVATOOLS.PGM: cannot execute

If I run it from qsh (which to me is just a mysterious black box that makes
the db2 cli tool work.) I get no error.

This page
https://www.ibm.com/developerworks/community/blogs/tjbarker?lang=en seems
to indicate I should either run it from qshell (a command that doesn't
exist on PASE or a 5250 session) or change one of the jars in my classpath.
I'm not sure what to do though. Here are the contents of the script:

bash-4.2$ cat ./sqlwbconsole.sh
#!/bin/sh
# Start SQL Workbench/J in console mode

# resolve links - $0 may be a softlink
PRG="$0"

while [ -h "$PRG" ] ; do
ls=`ls -ld "$PRG"`
link=`expr "$ls" : '.*-> \(.*\)$'`
if expr "$link" : '/.*' > /dev/null; then
PRG="$link"
else
PRG=`dirname "$PRG"`/"$link"
fi
done

scriptpath=`dirname "$PRG"`

JAVACMD="java"

if [ -x "$scriptpath/jre/bin/java" ]
then
JAVACMD="$scriptpath/jre/bin/java"
elif [ -x "$WORKBENCH_JDK/bin/java" ]
then
JAVACMD="$WORKBENCH_JDK/bin/java"
elif [ -x "$JAVA_HOME/jre/bin/java" ]
then
JAVACMD="$JAVA_HOME/jre/bin/java"
elif [ -x "$JAVA_HOME/bin/java" ]
then
JAVACMD="$JAVA_HOME/bin/java"
fi

cp=$scriptpath/sqlworkbench.jar
cp=$cp:$scriptpath/dom4j-1.6.1.jar
cp=$cp:$scriptpath/poi-ooxml-schemas.jar
cp=$cp:$scriptpath/poi-ooxml.jar
cp=$cp:$scriptpath/poi.jar
cp=$cp:$scriptpath/stax-api-1.0.1.jar
cp=$cp:$scriptpath/xmlbeans-2.3.0.jar
cp=$cp:$scriptpath/ext/*

$JAVACMD -Djava.awt.headless=true \
-Xmx512m \
-Dvisualvm.display.name=SQLWorkbench \
-cp $cp workbench.console.SQLConsole $@


What do I try next?

Regards,

Justin

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].