If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Command Editor from Web

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-11-08, 12:07
aysan aysan is offline
Registered User
 
Join Date: Jan 2008
Posts: 3
Command Editor from Web

Hello, I am trying to get something like db2 command editor from web i.e. I want to execute queries (xquery) from web browser without a need of db2 client installation. I've heard that it is possible with the use of websphere, however I could not find anything usefull. I'll be happy if somebody helps! Thanks...
Reply With Quote
  #2 (permalink)  
Old 01-11-08, 14:08
azs0309 azs0309 is offline
Registered User
 
Join Date: Jan 2008
Posts: 88
Websphere is a application server. and u have create and deploy java applications to make it possible. otherwise u can search for some db2 third party tools which allows u to access db2 using web browser....or u can write ur own perl CGI script

just a question what kind of query u want to execute ..is it for monitoring or just normal queries...
Reply With Quote
  #3 (permalink)  
Old 01-11-08, 15:55
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #4 (permalink)  
Old 01-12-08, 09:04
aysan aysan is offline
Registered User
 
Join Date: Jan 2008
Posts: 3
I will use it for monitoring purposes. By the way, what is the difference between installing a db2 client and dbvisualizer software. Because I want to execute queries from web browser. I will create a database in my server and then people will write some queries (xml queries for monitoring purposes) from their home PCs. I do not want all of them to install a db2 client. I am wondering if they can execute their queries from web browser and then see the results.
Thanks...
Reply With Quote
  #5 (permalink)  
Old 01-13-08, 09:08
azs0309 azs0309 is offline
Registered User
 
Join Date: Jan 2008
Posts: 88
If I am not wrong they need to have atleast run time client...
Reply With Quote
  #6 (permalink)  
Old 01-13-08, 15:15
Peter.Vanroose Peter.Vanroose is offline
Registered User
 
Join Date: Sep 2004
Location: Belgium
Posts: 1,079
Quote:
Originally Posted by aysan
I will create a database in my server and then people will write some queries (xml queries for monitoring purposes) from their home PCs. I do not want all of them to install a db2 client.
In that case you will have to install a DB2 client just on the web server, where the incoming web client requests (queries) are sent through the DB2 client (by using some sort of cgi script) to the DB2 server.
(Of course, DB2 client and server may reside on the same computer, but this is not necessary.)
__________________
--_Peter Vanroose,
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting
__http://www.abis.be/
Reply With Quote
  #7 (permalink)  
Old 01-14-08, 18:04
aysan aysan is offline
Registered User
 
Join Date: Jan 2008
Posts: 3
I have found something called IBM Web Query tool.
I think it is what I am looking for. Do you know anything about it?
It is licensed. I could not found any trial version from net. Do you know any tool like that which is free?
Thanks...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On