How to count number of distinct rows3179 (9/21/2007 8:38:58 AM) comp.databases.mysql Hi all I want to count the number of distinct rows. how to rewrite below query ? select distinct modifyts_date, sync_last_begin_date from pub.order_sync; ..... .... 2007-09-06 2007-09-07 2007-09-07 200... moonhk
RAID 10 iostat report 100% usage083 (9/4/2007 8:26:15 AM) comp.unix.aix Hi All We have RAID 10 on AIX 5.2( 6 x 72GB). iostat report 100% usage at peak hours, What is impact on our database application ? How to check RAID 10 harddisk configuration ? I just using below command to ... moonhk
cygwin bash shell script using ls problem573 (8/25/2007 7:58:40 AM) comp.unix.shell Hi All How ls can not able to using in cygwin bash shell script ? bash-3.2$ uname -a CYGWIN_NT-5.1 moon 1.5.24(0.156/4/2) 2007-01-31 10:57 i686 Cygwin bash-3.2$ #!/usr/bin/bash echo "eric" date "+%Y/%m/%d %... moonhk
how to pass value to awk with space and ":" ?397 (8/22/2007 4:13:09 AM) comp.lang.awk Hi All Do you know how to pass value to awk with space and ":" ? When TIME=`date +%Y/%m/%d %H:%M:%S` not work PROCESS() { TIME=`date +%Y/%m/%d.%H.%M.%S` ps -e -o pid,ppid,pcpu,cpu,etime,time,vsz,user,rssize... moonhk
AIX ps why %CPU no change065 (8/21/2007 9:24:06 AM) comp.unix.aix Hi All What %CPU no chnage as CP value have been changed ? # ps -e -o pid,ppid,pcpu,cpu,etime,time,vsz,user,rssize,comm PID PPID %CPU CP ELAPSED TIME VSZ USER RSS COMMAND 1753166... moonhk
AIX vmstat -s833 (8/20/2007 9:31:51 AM) comp.unix.aix Hi All What is different between page ins/outs and paging space page ins/ out ? vmstat -s 1889201253 total address trans. faults 716070874 page ins 268266358 page outs ... moonhk
How to show swap size without using swap -l ?453 (8/13/2007 7:55:24 AM) comp.unix.aix Hi All How to show swap size without using swap -l ? Can able using java program to display swap size. due to , Execute permission denied. Admin will not chmod to 755. swap -l ksh: swap: 0403-006 Execute perm... moonhk
How to send html mail on aix5135 (7/18/2007 8:03:25 AM) comp.unix.shell Following code can send html content on Sun Solaris. Do you know how to apply on AIX ? Due to AIX mailx without -t parameter. mailx -t An important link to look at! Here's an important link EOF ... moonhk
Load Average Question052 (7/5/2007 7:22:40 AM) comp.unix.aix Hi All ls below load average normal ? 03:21PM up 31 days, 19:34, 725 users, load average: 7.13, 7.78, 7.23 System Model: IBM,9117-570 Number Of Processors: 3 Processor Clock Speed: 1656 MHz CPU Type: 6... moonhk
Question about swap space is used up345 (7/4/2007 3:27:12 AM) comp.unix.aix Hi All Our AIX machine, running database application have 750 users. What will be happen when swap space is used up. At the peek time, about 69% of swap area used. The config as below about 5GB RAM 3GB SWAP a... moon_ils-se(53)
Dir filter how to set ?418 (8/17/2006 6:50:17 AM) comp.lang.java.programmer Now. Output as below, I want just list out *.java , how to using filter ? 1 i =3D 60, 2003-01-22 23:01:02, .\testing\template.java 1 i =3D 61, 2003-01-12 01:38:02, .\testing\Triangle.class 1 i... moon_ils-se(53)
Fatching a web page with space in url326 (8/15/2006 5:38:33 PM) comp.lang.java.programmer I tried to fatch a wab page in java as following public static String downloadWWWPage(String pageAddr) throws IOException { .... URL url = new URL(pageAddr); String websiteAddress = url.getHost(); S... coolshare(39)
How to program with proxy921 (8/11/2006 8:09:25 AM) comp.lang.java.programmer Below program worked before. How to program with proxy with input User name and password ? import java.util.*; import java.io.*; import java.net.*; public class eproxy_tofile { public static void main(Stri... moon_ils-se(53)
AIX vmstat -s833 (8/20/2007 9:31:51 AM) comp.unix.aix Hi All What is different between page ins/outs and paging space page ins/ out ? vmstat -s 1889201253 total address trans. faults 716070874 page ins 268266358 page outs ... moon_ils-se(53)
How to show swap size without using swap -l ?453 (8/13/2007 7:55:24 AM) comp.unix.aix Hi All How to show swap size without using swap -l ? Can able using java program to display swap size. due to , Execute permission denied. Admin will not chmod to 755. swap -l ksh: swap: 0403-006 Execute perm... moon_ils-se(53)