Sponsored Content
Operating Systems Linux Ubuntu Configure DISPLAY variable for DB2 Post 302245825 by backslash on Saturday 11th of October 2008 07:48:09 AM
Old 10-11-2008
You need to be running an X-server on your PC like Exceed for windows or a X11 server (Gnome desktop/KDE etc)

If you are on a remote PC you will need to set your DISPLAY to IP_of_PC:0

e.g. export DISPLAY=192.1.1.123:0

If you are on a Linux desktop you will need to allow remote clients to display graphics on it. Use 'xhost +' as a starting point but you can make this more secure if you like. See 'man xhost'

You could also try vnc once you've installed vnc-server on your DB host.
 

10 More Discussions You Might Find Interesting

1. Cybersecurity

Display variable

Hi: Im trying to change the display setting from my Linux server to Linux workstation but a Refused connection by server appear. The first task that I doing is to export the DISPLAY variable on my Linux Workstation so I tried to execute several X programs with the Refused Connection message.... (2 Replies)
Discussion started by: dansanmex
2 Replies

2. UNIX for Dummies Questions & Answers

Display from a variable using echo.

I have a variable that is outputting a lot of space. here has been 45 lines returned ... how can I remove the spaces between the "been and the 45" CODE: fil_len=`wc -l < coshb.txt` if ; then cat coshb.txt | more echo " " echo "There has been ${fil_len} lines... (4 Replies)
Discussion started by: jagannatha
4 Replies

3. Shell Programming and Scripting

How to read variable with no display

I'll be reading user name and password from the person while running a shell script so that he is authenticated. The challenge here is to read the password variable without displaying on screen. Is there a way? I presently do it displaying it on the screen as echo " please enter your... (9 Replies)
Discussion started by: dayanandra
9 Replies

4. UNIX for Dummies Questions & Answers

How to export the Display variable

I'm trying to open an xwindow on my Sun server. What am I doing wrong? # echo $SHELL /sbin/sh # # export DISPLAY=localhost:0.0 DISPLAY=localhost:0.0: is not an identifier Thank you! (1 Reply)
Discussion started by: FredSmith
1 Replies

5. Shell Programming and Scripting

DB2 and Unix Variable .....

Guys Quick help... ---------------------------- #!/usr/bin/ksh db2 -x "select count(*) from ${SCHEMA}.EMP"> $HOME/count.dat COUNT=`cat $HOME/count.dat` echo Table Count: $COUNT if ( $COUNT -eq 0 ); then echo Record Count in Table is 0 exit 1 fi echo Records Exist... (2 Replies)
Discussion started by: freakygs
2 Replies

6. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

7. Shell Programming and Scripting

How to pass a variable as a parameter to DB2 database from shell script

I need to pass a variable as a parameter from shell script into a DB2 database. var=bhuk_1123_Q_11/22/09 select * from tbl1 where serial_id='$var'; I have tried executing it using db2 -tvf scriptname Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Discussion started by: ss3944
2 Replies

8. UNIX for Dummies Questions & Answers

DISPLAY Environment Variable

I've seen articles which say "export DISPLAY=<IP>:0" and others which say "export DISPLAY=<IP>:0.0". Can someone explain what the difference is? TIA (4 Replies)
Discussion started by: cjhancock
4 Replies

9. Shell Programming and Scripting

Assigning value of a select count(*) from tablename ( run on db2 ) to a unix variable

Hi All, I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2. I want to assign the output of a select count(*) from tablename to a unix variable in a shell script. I am using ksh. The database used to... (3 Replies)
Discussion started by: Siddarth
3 Replies

10. Shell Programming and Scripting

Variable arangement to display

Hello For this future package for community, i'd like to know your preference on this presented 'issue'. Writing some commands which will display some strings, using another command supporting 3 strings to be supplied, i wonder how the 'default output' should look like. Let me use a... (2 Replies)
Discussion started by: sea
2 Replies
SQL::ReservedWords::DB2(3pm)				User Contributed Perl Documentation			      SQL::ReservedWords::DB2(3pm)

NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2 SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) { print "$word is a reserved DB2 word!"; } DESCRIPTION
Determine if words are reserved by DB2. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8. is_reserved_by_db2v5( $word ) Returns a boolean indicating if $word is reserved by DB2 5. is_reserved_by_db2v6( $word ) Returns a boolean indicating if $word is reserved by DB2 6. is_reserved_by_db2v7( $word ) Returns a boolean indicating if $word is reserved by DB2 7. is_reserved_by_db2v8( $word ) Returns a boolean indicating if $word is reserved by DB2 8. reserved_by( $word ) Returns a list with DB2 versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_db2v5 is_reserved_by_db2v6 is_reserved_by_db2v7 is_reserved_by_db2v8 reserved_by words SEE ALSO
SQL::ReservedWords <http://www-306.ibm.com/software/data/db2/udb/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)
All times are GMT -4. The time now is 09:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy