Sponsored Content
Full Discussion: problem
Top Forums Shell Programming and Scripting problem Post 84087 by YoYo on Wednesday 21st of September 2005 05:08:29 PM
Old 09-21-2005
the original query looks like:

select /*+ ordered index (a fk_event_hist_1) */
trunc(start_dtg) as tran_date
, a.event_code
, b.event_desc
, sum(case when error_text like 'SystemError:Operation Time Out (Server Side)%' then 1
else 0 END ) as Time_out_count
, count(*)
from trn_event_history a
, trn_event b
where trunc(start_dtg)>=trunc(sysdate)-2
and a.event_code = b.event_code
group by trunc(start_dtg), a.event_code, b.event_desc
having sum(case when error_text like 'SystemError:Operation Time Out (Server Side)%' then 1
else 0 END ) > 0
order by 1,3


but it doesnt work in unix script.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SSH Problem auth problem

Hi, Just recently we seem to be getting the following error message relating to SSH when we run the UNIX script in background mode: warning: You have no controlling tty. Cannot read confirmation.^M warning: Authentication failed.^M Disconnected; key exchange or algorithm negotiation... (1 Reply)
Discussion started by: budrito
1 Replies

2. Shell Programming and Scripting

problem with dd command or maybe AFS problem

Hi, folks. Sorry for bothering, but maybe someone could help me please. The problem is the following: there is some script that copies files from local file system to AFS. The copying is performed with dd command. The script copies data into some AFS volumes. The problem appeared with one... (0 Replies)
Discussion started by: Anta
0 Replies

3. Shell Programming and Scripting

ssh script problem problem

Hi Please help me with the following problem with my script. The following block of code is not repeating in the while loop and exiting after searching for first message. input_file ========== host001-01 host001-02 2008-07-23 13:02:04,651 ConnectionFactory - Setting session state... (2 Replies)
Discussion started by: pcjandyala
2 Replies

4. Solaris

problem in finding a hardware problem

Hi I am right now facing a strange hardware problem. System get booted with the following error: Fatal Error Reset CPU 0000.0000.0000.0003 AFSR 0100.0000.0000.0000 SCE AFAR 0000.07c6.0000.1000 SC Alert: Host System has Reset It happen 4 or 5 times and get the same error every time.I... (8 Replies)
Discussion started by: girish.batra
8 Replies

5. AIX

user login problem & Files listing problem.

1) when user login to the server the session got colosed. How will resolve? 2) While firing the command ls -l we are not able to see the any files in the director. but over all view the file system using the command df -g it is showing 91% used. what will be the problem? Thanks in advance. (1 Reply)
Discussion started by: pernasivam
1 Replies

6. Red Hat

Mail Problem. Maybe, it is a DNS Problem!

Hi, i've a redhat linux 9 upadated by redhat from 7 version to 9 version. A couple of days ago i was a problem with my mail, in other words i'm not able to get any email nor to send any email. I've a proxy configuration and i tried to set iptables in order to verify the port. The 110,255 and 995... (1 Reply)
Discussion started by: pintalgi
1 Replies

7. UNIX for Dummies Questions & Answers

DHCP problem and eth1 problem

At work I am trying to get this one Linux machine (let's call it ctesgm07) to behave like another Linux machine that we have (let's call it test007). test007 returns the following version info: cat /etc/debian_version: lenny/sid uname -a: Linux test007 2.6.27-7-generic #1 SMP Tue Nov 4... (0 Replies)
Discussion started by: sllinux
0 Replies

8. AIX

AIX OS problem? network problem?

Dear ALL. I installed AIX OS on customer sites. but Only one site is too slow when I connected telnet, ftp.. Ping is too fast. but telnet and FTP is not connected.. of course i check the configuration file on aix but it's normal. Do any Idea?? thanks in advance. - Jun - (3 Replies)
Discussion started by: Jeon Jun Seok
3 Replies

9. IP Networking

Problem with forwarding emails (SPF problem)

Hi, This is rather a question from a "user" than from a sys admin, but I think this forum is apropriate for the question. I have an adress with automatic email forwarding and for some senders (two hietherto), emails are bouncing. This has really created a lot of problems those two time so I... (0 Replies)
Discussion started by: carwe
0 Replies

10. UNIX for Dummies Questions & Answers

sed Or Grep Problem OR Terminal Problem?

I don't know if you guys get this problem sometimes at Terminal but I had been having this problem since yesterday :( Maybe I overdid the Terminal. Even the codes that used to work doesn't work anymore. Here is what 's happening: * I wanted to remove lines containing digits so I used this... (25 Replies)
Discussion started by: Nexeu
25 Replies
PAPI_event_info_t(3)						       PAPI						      PAPI_event_info_t(3)

NAME
PAPI_event_info_t - SYNOPSIS
Data Fields unsigned int event_code char symbol [1024] char short_descr [64] char long_descr [1024] int component_index char units [64] int location int data_type int value_type int timescope int update_type int update_freq unsigned int count unsigned int event_type char derived [64] char postfix [256] unsigned int code [12] char name [12][256] char note [1024] Field Documentation unsigned int PAPI_event_info_t::code[12] array of values that further describe the event: o presets: native event_code values o native:, register values(?) int PAPI_event_info_t::component_index component this event belongs to unsigned int PAPI_event_info_t::count number of terms (usually 1) in the code and name fields o presets: these are native events o native: these are unused int PAPI_event_info_t::data_type data type returned by PAPI char PAPI_event_info_t::derived[64] name of the derived type o presets: usually NOT_DERIVED o native: empty string unsigned int PAPI_event_info_t::event_code preset (0x8xxxxxxx) or native (0x4xxxxxxx) event code unsigned int PAPI_event_info_t::event_type event type or category for preset events only int PAPI_event_info_t::location location event applies to char PAPI_event_info_t::long_descr[1024] a longer description: typically a sentence for presets, possibly a paragraph from vendor docs for native events char PAPI_event_info_t::name[12][256] < names of code terms: - presets: native event names, o native: descriptive strings for each register value(?) char PAPI_event_info_t::note[1024] an optional developer note supplied with a preset event to delineate platform specific anomalies or restrictions char PAPI_event_info_t::postfix[256] string containing postfix operations; only defined for preset events of derived type DERIVED_POSTFIX char PAPI_event_info_t::short_descr[64] a short description suitable for use as a label char PAPI_event_info_t::symbol[1024] name of the event int PAPI_event_info_t::timescope from start, etc. char PAPI_event_info_t::units[64] units event is measured in int PAPI_event_info_t::update_freq how frequently event is updated int PAPI_event_info_t::update_type how event is updated int PAPI_event_info_t::value_type sum or absolute Author Generated automatically by Doxygen for PAPI from the source code. Version 5.2.0.0 Tue Jun 17 2014 PAPI_event_info_t(3)
All times are GMT -4. The time now is 08:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy