Sponsored Content
Full Discussion: Querying database from unix
Top Forums Shell Programming and Scripting Querying database from unix Post 302201462 by robotronic on Monday 2nd of June 2008 09:48:28 AM
Old 06-02-2008
I think no Smilie

Dhruva's explanation is right. You may try to see what is the wait event of the session when is "hung".

Or maybe the table is locked, but if you're doing only queries (no DML) this is not the case.
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connecting and Querying DB2 database from Unix Script?

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies

2. UNIX for Advanced & Expert Users

Connecting to DB2 database on Mainframe and Querying DB

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies

3. HP-UX

Querying HP VA array

Hello, all... I've got an older HP-UX 11i machine hooked up to an HP VA array. I've never worked with VA arrays, so I was wondering if anyone could point me in the direction of some documentation on querying and manipulating VAs (HP VAs for Dummies or something). I'm used to EMC arrays, so... (2 Replies)
Discussion started by: kknigga
2 Replies

4. AIX

Servers still querying old DNS server?

Hello, I've created new DNS servers and changed all of the clients /etc/resolv.conf to point to them, but when I check the old DNS logs, I see that the clients are still querying it. Does anybody know why? thanks, (2 Replies)
Discussion started by: ctcuser
2 Replies

5. Solaris

commands hanging when querying hardware

Hi all Got another strange one. If I try to enquire about the hardware, the command hangs implying Ive got a hardware issue. So, if I execute :- iostat -en sysdef - ( stops at the devices part ) format cfgadm -al Anything that searches the devices, then the command hangs. ... (4 Replies)
Discussion started by: sbk1972
4 Replies

6. Red Hat

Error in querying file information

Hi, We have one application running where there is Linux Machine. For some some process I found the following message came, error 5.8/116455-02/116455-02.zip Error in querying file information: Permission denied :confused: If anybody has any idea for this please let me... (2 Replies)
Discussion started by: sptr
2 Replies

7. Shell Programming and Scripting

Generic script for Querying a DB

I have a few databases that i need to get some basic output from... so I'll be returning 1 or 2 records from a variety of different databases and the input queries will always differ. What im looking for is a generic script that I can use across of the databases. Theory being i have: ... (2 Replies)
Discussion started by: atelford
2 Replies

8. Shell Programming and Scripting

Querying v$session table

Hi All, I'm using below code entry_data_control=`sqlplus ${sysuser}/${syspwd} << data_control whenever sqlerror exit sql.sqlcode; whenever oserror exit failure; INSERT INTO LSHADMIN.STUDY_LEVEL_TABLE(SESSION_SID,SESSION_SERIAL_NO,FILE_NAME) ... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
Jifty::Subs(3pm)					User Contributed Perl Documentation					  Jifty::Subs(3pm)

NAME
Jifty::Subs - Configure subscriptions for the current window or session SYNOPSIS
my $sid = Jifty->subs->add( class => 'Tick', queries => [{ like => '9' }], mode => 'Replace', region => "clock-time", render_with => '/fragments/time', ); Jifty->subs->cancel($sid); my @sids = Jifty->subs->list; DESCRIPTION
METHODS
add PARAMHASH Add a subscription for the current window or session. Takes the following parameters class What class of object shall we subscribe to notifications on queries An array of queries to match items of class "class" against. The implementation of "queries" is dependent on the type of object events are being recorded against mode How should the fragment sent to the client on matching events be rendered. Valid modes are "Replace", "Bottom" and "Top" region The moniker of the region that updates to this subscription should be rendered into render_with The path of the fragment used to render items matching this subscription effect The effect to use when showing the region, if any. effect_args Arguments to the effect remove_effect The effect to use when removing the old value of the region, if any. remove_effect_args Arguments to the remove effect coalesce If multiple events would cause the update of the given region with the same "render_with" path, merge them and only render the region once, with the latest update. cancel CHANNEL_ID Cancels session or window's subscription to CHANNEL_ID list [window/sessionid] Returns a lost of channel ids this session or window is subscribed to. update_on PARAMHASH Like "add", but provides a sane set of defaults for updating the current region, based on inspection of the current region's properties. "queries" is set to the region's arguments, and "class" is left unspecified. perl v5.14.2 2010-09-25 Jifty::Subs(3pm)
All times are GMT -4. The time now is 02:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy