SUNDB Tablespace & User 생성

// sysdba 계정 접속

[qcubic@symphony ~]$ gsql --as sysdba

// tablespace and datafile 확인

gSQL> select * from x$tablespace;

gSQL> select * from x$datafile;

// data tablespace 생성

gSQL> create tablespace TBS_DATA_USR datafile 'tbs_data_usr_01.dbf' size 10m;

Tablespace created.

// data tablespace 추가

gSQL> alter tablespace TBS_DATA_USR add datafile 'tbs_data_usr_02.dbf' size 10m;

Tablespace altered.

// temp tablespace 생성

gSQL> create temporary tablespace TBS_TEMP_USR memory 'TBS_TEMP_USR_01' size 10m;

Tablespace created.

// temp tablespace 추가

gSQL> alter tablespace TBS_TEMP_USR add memory 'TBS_TEMP_USR_02' size 10m;

Tablespace altered.

// id: orange / pw: orange 계정 생성하고, tablespace 지정

gSQL> create user orange identified by orange default tablespace TBS_DATA_USR temporary tablespace TBS_TEMP_USR;

// orange 계정에 권한 부여

gSQL> grant all privileges on database to orange;

Grant succeeded.

// 신규 생성한 orange 계정으로 접속

[qcubic@symphony ~]$ gsql orange orange;

기억해야 하는것

from: http://blog.donga.com/juneauatom/archives/449

삶을 살면서
그 중에 중요한 하나는,
약자를 보호하고 남을 배려하는 것과 정직함을 삶의 근간으로 삼아야 한다.

우리가 꼭 기억해야 할 것들이 많지만,

나의 기쁨, 나의즐거움, 나의 행복이란 것이
남에게 어려움, 고통, 불행이 되지 않는가를 살피는 일이다.

SUNDB for JAVA Connection

SundbDataSource

import sunje.sundb.jdbc.SundbDataSource; SundbDataSource ds = new SundbDataSource(); ds.setServerName("127.0.0.1"); ds.setPortNumber(22581); ds.setDatabaseName("test"); ds.setUser("TEST"); ds.setPassword("test"); Connection con = ds.getConnection();

DriverManager

properties prop = new properties(); prop.setProperty("user", "aaa"); prop.setProperty("password", "bbb"); Connection con = DriverManager.getConnection("jdbc:sundb://127.0.0.1:2581/test", prop);

AIX Command

from http://bhami.com/rosetta.html

TASK \ OS	AIX	OS / TASK
OS notes	By IBM, with input from System V, BSD, etc. Runs mainly on IBM RS/6000, System p, Power Systems, and related hardware.	OS notes
administrative GUI	smit smitty wsm	administrative GUI
managing users	useradd (5+) userdel (5+) usermod (5+) lsuser mkuser chuser rmuser usrck	managing users
TASK \ OS	AIX	OS / TASK
list hardware configuration	prtconf lscfg lsattr lsdev lspath	list hardware configuration
unique id useful for licensing	uname -u uname -m lsattr -El sys0 -a systemid	unique id useful for licensing
show/set EEPROM/NVRAM values	bootlist -o -m normal	show/set EEPROM/NVRAM values
add device without reboot	cfgmgr -v mkdev	add device without reboot
remove device	rmdev	remove device
tape device	/dev/rmt0	tape device
stdin/ stdout/ stderr	?	stdin/ stdout/ stderr
X kvm config	?	X kvm config
TASK \ OS	AIX	OS / TASK
read a disk label	lspv	read a disk label
whole disk in partition	hdisk[0,1,2,...]	whole disk in partition
label a disk	mkvg	label a disk
partition a disk	mklv	partition a disk
TASK \ OS	AIX	OS / TASK
kernel	/unix	kernel
show/set kernel parameters	vmo ioo schedo	show/set kernel parameters
limit physical memory	rmss	limit physical memory
loaded kernel modules	genkex vxketadm -s	loaded kernel modules
load module	vxketadm modname load cfgmgr mkdev -l devname	load module
unload module	rmdev -l devname	unload module
make disk bootable	bosboot -a	make disk bootable
startup scripts	/etc/rc* /etc/inittab	startup scripts
start/ stop/ config services	startsrc stopsrc lssrc refresh srcmstr	start/ stop/ config services
shutdown (& power off if possible)	shutdown -Fh	shutdown (& power off if possible)
run levels 1 *=normal states for more detail see www.phildev.net/runlevels.html	2: multiuser 6: reboot	run levels 1 *=normal statesfor more detail see www.phildev.net/runlevels.html
show runlevel 1	who -r	show runlevel 1
time zone info	/etc/environment ($TZ)	time zone info
check swap space	lsps -a	check swap space
core dump management	chcore sysdumpdev	core dump management
bind process to CPU	bindprocessor	bind process to CPU
TASK \ OS	AIX	OS / TASK
"normal" filesystem	jfs	"normal" filesystem
volume-based filesystem	jfs2	volume-based filesystem
file system description	/etc/filesystems mount lsfs	file system description
volume manipulation	smitty vg smitty lvm smitty jfs smitty storage lsvg; varyonvg; varyoffvg mkvg; chvg; reducevg; extendvg exportvg; importvg mklv; chlv; rmlv mkfs; crfs; rmfs	volume manipulation
create filesystem	crfs mkfs	create filesystem
file system debugging and recovery	dfsck fsck fsdb	file system debugging and recovery
create non-0-length empty file	lmktemp	create non-0-length empty file
convert DOS-format text to Unix format	strings dosfile.txt > unixfile.txt	convert DOS-format text to Unix format
mount CDROM	mount -v cdrfs -o ro /dev/cd0 /cdrom smitty cdrom	mount CDROM
eject CDROM	?	eject CDROM
create/mount ISO image	mkcd	create/mount ISO image
ACL management	aclget aclput acledit ls -e	ACL management
Fibre Channel / SAN	fcstat lscfg -vl fcs0 lsattr -El fcs0 lspath	Fibre Channel / SAN
TASK \ OS	AIX	OS / TASK
NFS share definitions	/etc/exports /etc/xtab	NFS share definitions
NFS share command	exportfs -a mknfsexp	NFS share command
NFS information	nfsstat nfso -as	NFS information
name resolution order	/etc/netsvc.conf /etc/resolv.conf	name resolution order
show network interface info	ifconfig -a no -a netstat -i netstat -v lsattr -E -l entX entstat	show network interface info
change IP	smitty chinet chdev -a netaddr= newIP -I en# mktcpip rmtcpip	change IP
start DHCP client	dhcpcd	start DHCP client
ping one packet	ping -c 1 hostname	ping one packet
sniff network	iptrace ipreport	sniff network
route definitions	netstat -r route	route definitions
telnetd, ftpd banner	/etc/security/login.cfg	telnetd, ftpd banner
set date/time(from net: ntp or other)	ntpdate	set date/time(from net: ntp or other)
TASK \ OS	AIX	OS / TASK
auditing	audit auditpr auditselect lsaudrec	auditing
encrypted passwords in	/etc/security/passwd	encrypted passwords in
min password length	/etc/security/user	min password length
allow/deny root logins	/etc/security/user	allow/deny root logins
firewall config	genfilt smitty ipsec4 wsm network	firewall config
TASK \ OS	AIX	OS / TASK
show installed software	lslpp -L	show installed software
file is in which package	lslpp -w filerpm -qif filewhich_fileset	file is in which package
add software	smitty install rpm -ihv installp -acgxYd /sourcedir [fileset|ALL]	add software
precompiled binaries of GPLware and freeware	perzl.org/aix/ bullfreeware.com www.ibm.com/systems/power/ software/aix/linux/toolbox/altlic.html	precompiled binaries of GPLware and freeware
C compiler	/usr/ibmcxx/bin/cc /usr/vac/bin/cc ($)	C compiler
show patch level and/or patches	instfix -ivq oslevel -s emgr -l	show patch level and/or patches
patch tool	installp smitty update_all emgr	patch tool
configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html	dump -H ldd	configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html
link library path	$LIBPATH	link library path
tracing utility	probevue (6+) trace syscalls truss watch trcrpt	tracing utility
define user defaults	/etc/security/ mkuser.default /etc/environment	define user defaults
csh global .login	/etc/csh.login	csh global .login
default syslog and messages	/var/adm/syslog /var/adm/messages	default syslog and messages
system error reporting tool	errpt errclear	system error reporting tool
performance monitoring	ftp://ftp.software.ibm.com/ aix/tools/perftools/perfpmr vmstat; iostat; sar; filemon; topas; trace; svmon; netpmon; proctree	performance monitoring
match process to file or port	procfiles (5.2+, files only)	match process to file or port
manage various logs	snap	manage various logs
X pop-up	/usr/dt/bin/dterror.ds	X pop-up
Wikipedia	AIX	Wikipedia
FAQs (see also faqs.org)	www.faqs.org/faqs/ aix-faq/part1/ preamble.html	FAQs (see also faqs.org)
blogs	?	blogs
mailing list	AIX-L@pucc. princeton.edu (LISTSERV)	mailing list
mailing list archives	www.marist. edu/htbin/wlvindex? ADSM-L marc.theaimsgroup.com/ ?l=aix-l&r=1&w=2	mailing list archives
man pages www.freebsd.org/ cgi/man.cgi	publib.boulder.ibm.com/infocenter/ aix/v7r1/topic/ com.ibm.aix.cmds/ alphabeticallistofcommands.htm	man pages www.freebsd.org/ cgi/man.cgi
newsgroup(s) and forums groups.google	comp.unix.aix www.thp.uni-duisburg.de/ cuaix/cuaix.html	newsgroup(s) and forums groups.google
user groups	www.userblue.org	user groups
magazines	n/a	magazines
vendor home page	www.developer.ibm.com/ tech/map/aixrm.html www-941.ibm.com/ collaboration/ wiki/display/WikiPtype/Home	vendor home page
vendor docs and patches (see also man pages)	www.redbooks.ibm.com www.ibm.com/ developerworks/aix techsupport.services. ibm.com/ server/support? view=pSeries	vendor docs and patches (see also man pages)
vendor phone (US)	800-426-7378 (800-IBM-SERV)	vendor phone (US)
wikis	www.ibm.com/developerworks/ wikis/display/WikiPtype/Home	wikis
TASK / OS	AIX	OS \ TASK

HP-UX Command

from http://bhami.com/rosetta.html

TASK \ OS	HP-UX	OS / TASK
OS notes	Hewlett-Packard	OS notes
administrative GUI	sam smh (11.31+)	administrative GUI
managing users	useradd userdel usermod getprpw modprpw pwget	managing users
TASK \ OS	HP-UX	OS / TASK
list hardware configuration	ioscan dmesg (if you're lucky) adb model stm (from the SupportPlus CDROM) bdf (like most vendors' df)getconf machinfo (11.23+) print_manifest	list hardware configuration
unique id useful for licensing	uname -i	unique id useful for licensing
show/set EEPROM/NVRAM values	setboot stm	show/set EEPROM/NVRAM values
add device without reboot	inf -e ioscan -fnC devtype; insf -C devtype	add device without reboot
remove device	rmsf	remove device
tape device	/dev/rmt/0m	tape device
stdin/ stdout/ stderr	?	stdin/ stdout/ stderr
X kvm config	itemap	X kvm config
TASK \ OS	HP-UX	OS / TASK
read a disk label	scsimgr (11.31+)diskinfo pvdisplay	read a disk label
whole disk in partition	?	whole disk in partition
label a disk	pvcreate	label a disk
partition a disk	smh (11.31+)lvcreate sam	partition a disk
TASK \ OS	HP-UX	OS / TASK
kernel	/hpux (9)/stand/vmunix (10+)	kernel
show/set kernel parameters	smh (11.31+) sam sysdef kmtune (11+)kctune (11.23+)getconf	show/set kernel parameters
limit physical memory	?	limit physical memory
loaded kernel modules	kmadmin -s kcmodule -a (11.23+)	loaded kernel modules
load module	kmadmin -L kcmodule module=loaded (11.23+)	load module
unload module	kmadmin -U kcmodule module=unused (11.23+)	unload module
make disk bootable	mkboot	make disk bootable
startup scripts	/etc/rc* (9) /etc/rc.config.d (preferred) /sbin/rc* (10+) /sbin/init.d/	startup scripts
start/ stop/ config services	?	start/ stop/ config services
shutdown (& power off if possible)	shutdown -yh 0	shutdown (& power off if possible)
run levels 1 *=normal states for more detail see www.phildev.net/runlevels.html	0: shut down s,S: single-user 1: sys admin 2: multiuser 3*: share NFS 4*: start GUI 5: user-defined 6: user-defined	run levels 1 *=normal statesfor more detail see www.phildev.net/runlevels.html
show runlevel 1	who -r	show runlevel 1
time zone info	/usr/lib/tztab	time zone info
check swap space	swapinfo	check swap space
core dump management	coreadm	core dump management
bind process to CPU	psrset -b mpsched -c intctl	bind process to CPU
TASK \ OS	HP-UX	OS / TASK
"normal" filesystem	hfs vxfs (11.0+)	"normal" filesystem
volume-based filesystem	jfs (vxfs) LVM VxVM ($)	volume-based filesystem
file system description	/etc/checklist (9) /etc/fstab (10+)	file system description
volume manipulation	vg*; lv*; pv* extendfs fsadm	volume manipulation
create filesystem	mkfs newfs	create filesystem
file system debugging and recovery	fsck fsdb	file system debugging and recovery
create non-0-length empty file	prealloc	create non-0-length empty file
convert DOS-format text to Unix format	dos2ux	convert DOS-format text to Unix format
mount CDROM	pfs_mountd pfsd pfs_mount mount /dev/dsk/cxtydz4 /SD_CDROM mount -orr /dev/cdrom /mnt/cdrom (requires "Rock Ridge extension" patches, 11+)	mount CDROM
eject CDROM	?	eject CDROM
create/mount ISO image	nohup pfs_mountd&; nohup pfsd&; pfs_mount -t iso9660 -x unix pathToIso mountPoint	create/mount ISO image
ACL management	lsacl chacl getacl setacl	ACL management
Fibre Channel / SAN	scsimgr (11.31+) fcmsutil fcdlist tdutil tdlist tddiag	Fibre Channel / SAN
TASK \ OS	HP-UX	OS / TASK
NFS share definitions	/etc/exports /etc/dfs/dfstab (11.31+)	NFS share definitions
NFS share command	exportfs -a share (11.31+)shareall (11.31+) share_nfs (11.31+)	NFS share command
NFS information	nfsstat	NFS information
name resolution order	/etc/nsswitch.conf	name resolution order
show network interface info	nwmgr (11.31+) lanadmin landiag lanscan netstat -in ifconfig lanx	show network interface info
change IP	/sbin/set_parms initial ifconfig	change IP
start DHCP client	?	start DHCP client
ping one packet	ping hostname 10 1 (9) ping hostname -n 1 (10+)	ping one packet
sniff network	nettl netfmt	sniff network
route definitions	/etc/rc.config.d/netconf netstat -r	route definitions
telnetd, ftpd banner	/etc/inetd.conf (telnet)	telnetd, ftpd banner
set date/time(from net: ntp or other)	ntpdate	set date/time(from net: ntp or other)
TASK \ OS	HP-UX	OS / TASK
auditing	audisp audevent audomon audsys	auditing
encrypted passwords in	/etc/passwd (not Trusted)/.secure/etc/passwd (Trusted 9)/tcb/files/auth/ (10+) /etc/shadow (11.22+)	encrypted passwords in
min password length	/etc/default/security	min password length
allow/deny root logins	/etc/securetty	allow/deny root logins
firewall config	/etc/opt/ipf/ipf.conf	firewall config
TASK \ OS	HP-UX	OS / TASK
show installed software	rmfn, what (HP-UX 9) swlist (HP-UX 10+) swm list (11.31+)	show installed software
file is in which package	swlist -l file | grep file	file is in which package
add software	swm install (11.31+) swinstall	add software
precompiled binaries of GPLware and freeware	hpux.cs.utah.edu hpux.connect.org.uk	precompiled binaries of GPLware and freeware
C compiler	/opt/softbench/bin/cc ($) /bin/cc (9) /usr/bin/cc (10+; not necessarily ANSI; kernel builder only)	C compiler
show patch level and/or patches	swm list (11.31+) swlist -l product | grep PHsomeString	show patch level and/or patches
patch tool	update (9) swinstall (10+)	patch tool
configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html	chatr ldd (11+)kmadmin	configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html
link library path	$LD_LIBRARY_PATH (64-bit) $SHLIB_PATH (32- or 64-bit)	link library path
tracing utility	caliper fprof caliper ktrace trace (freeware)tusc (11+, freeware)	tracing utility
define user defaults	/etc/default /etc/PATH /etc/MANPATH /etc/default/*	define user defaults
csh global .login	/etc/csh.login	csh global .login
default syslog and messages	/var/adm/syslog/syslog.log /var/adm/sulog /var/spool/mqueue/syslog	default syslog and messages
system error reporting tool	evmshow (11.31+) smh (11.31+) dmesg sysdiag (9 and early10) stm/cstm/mstm/xstm (10.20+)EMS (from support CD)	system error reporting tool
performance monitoring	glance gpm caliper top; sar; vmstat; iostat; nfsstat; netstat; uustat; Glance($)ptree (11.31+)	performance monitoring
match process to file or port	lsof fuser	match process to file or port
manage various logs	?	manage various logs
X pop-up	/usr/dt/bin/dterror.ds	X pop-up
Wikipedia	HP-UX	Wikipedia
FAQs (see also faqs.org)	www.faqs.org/faqs/ hp/hpux-faq/preamble.html	FAQs (see also faqs.org)
blogs	?	blogs
mailing list	hpux-admin@ dutchworks.nl  (majordomo) hp-ux-l	mailing list
mailing list archives	www.dutch works.nl/  htbin/hpsysadmin	mailing list archives
man pages www.freebsd.org/ cgi/man.cgi	docs.hp.com/en/hpuxman_pages.html hpuxman_pages.html	man pages www.freebsd.org/ cgi/man.cgi
newsgroup(s) and forums groups.google	comp.sys.hp.hpux	newsgroup(s) and forums groups.google
user groups	connect-community.org hp-interex.com encompassus.org hptechnologyforum.com forums.itrc.hp.com HP DSPP	user groups
magazines	www.hpchronicle.com www.interex.org/hpuxusr www.hppro.com	magazines
vendor home page	hp.com/go/hpux	vendor home page
vendor docs and patches (see alsoman pages)	software.hp.comdocs.hp.com itrc.hp.com	vendor docs and patches (see alsoman pages)
vendor phone (US)	800-633-3600	vendor phone (US)
wikis	?	wikis
TASK / OS	HP-UX	OS \ TASK

Linux Command

from http://bhami.com/rosetta.html

TASK \ OS	Linux	OS / TASK
OS notes	(rh) = Red Hat, Mandrake, SUSE,... (deb) = Debian, Libranet,... (fed) = Fedora (gen) = Gentoo  (md) = Mandrake/Mandriva (SUSE) = SUSE	OS notes
administrative GUI	(rh, FC2+, RHEL4+) system-config* (rh) redhat-config* linuxconf (obsolete) (SUSE) yast2 (deb) dpkg-reconfigure (md) drakconf	administrative GUI
managing users	useradd usermod userdel adduser chage getent	managing users
TASK \ OS	Linux	OS / TASK
list hardware configuration	arch uname dmesg (if you're lucky) cat /var/log/dmesg /proc/* lshw dmidecode lspci lspnp lsscsi lsusb lsmod (SUSE) hwinfo /sys/devices/*	list hardware configuration
unique id useful for licensing	/sbin/ifconfig eth0	unique id useful for licensing
show/set EEPROM/NVRAM values	/dev/nvram (if you have it) hwclock nvsetenv	show/set EEPROM/NVRAM values
add device without reboot	udev (2.6+) udevtrigger modprobe kerneld insmod hotplug cardctl	add device without reboot
remove device	?	remove device
tape device	/dev/st0	tape device
stdin/ stdout/ stderr	/dev/fd/[012]	stdin/ stdout/ stderr
X kvm config	xorgcfg xorgconfig Xorg -configure system-config-display xf86config XFree86 -configure redhat-config-xfree86 /etc/X11/?dm	X kvm config
TASK \ OS	Linux	OS / TASK
read a disk label	fdisk -l	read a disk label
whole disk in partition	/dev/hda (e.g. if /dev/hda1 is a partition)	whole disk in partition
label a disk	cfdisk fdisk gdisk e2label	label a disk
partition a disk	parted (if you have it)cfdisk fdisk gdisk pdisk (on a MAC) (deb) mac-fdisk (on a MAC) (md) diskdrake	partition a disk
TASK \ OS	Linux	OS / TASK
kernel	/boot/vmlinuz* /boot/bootlx (see /etc/lilo.conf or /boot/grub/menu.lst)	kernel
show/set kernel parameters	/proc/* /proc/sys/* sysctl /etc/sysctl.conf	show/set kernel parameters
limit physical memory	mem= (in lilo.conf or /boot/grub/grub.conf)	limit physical memory
loaded kernel modules	lsmod	loaded kernel modules
load module	modprobe insmod	load module
unload module	rmmod modprobe -r	unload module
make disk bootable	(rh) mkbootdisk (deb) fdisk -A (and lilo to manipulate mbr)	make disk bootable
startup scripts	/etc/rc* (but may vary) /etc/init.d/ chkconfig service	startup scripts
start/ stop/ config services	(rh) service (rh) chkconfig (deb) sysv-rc-conf	start/ stop/ config services
shutdown (& power off if possible)	shutdown -Ph now shutdown -y -g0 -i0 halt poweroff	shutdown (& power off if possible)
run levels 1 *=normal states for more detail see www.phildev.net/runlevels.html	(set in /etc/inittab) 0: halt s,S,1: vendor-dependent 1: single-user 2-5*: multiuser 6: reboot	run levels 1 *=normal statesfor more detail see www.phildev.net/runlevels.html
show runlevel 1	/sbin/runlevel	show runlevel 1
time zone info	/usr/share/zoneinfo/ /etc/localtime	time zone info
check swap space	swapon -s cat /proc/meminfo cat /proc/swaps free	check swap space
core dump management	/proc/sys/kernel/core_pattern /proc/pid/coredump_filter	core dump management
bind process to CPU	taskset (sched-utils)	bind process to CPU
TASK \ OS	Linux	OS / TASK
"normal" filesystem	ext2 ext3 ReiserFS	"normal" filesystem
volume-based filesystem	LVM, LVM2 EVMS VxVM ($)	volume-based filesystem
file system description	/etc/fstab	file system description
volume manipulation	e2fsadm lvcreate lvremove lvextend vgdisplay	volume manipulation
create filesystem	mke2fs mkreiserfs mkdosfs mkfs.*	create filesystem
file system debugging and recovery	fsck debugfs e2undel	file system debugging and recovery
create non-0-length empty file	fallocate dd if=/dev/zero of=filename bs=1024k count=desired	create non-0-length empty file
convert DOS-format text to Unix format	dos2unix	convert DOS-format text to Unix format
mount CDROM	mount /mnt/cdrom (deb) mount /cdrom	mount CDROM
eject CDROM	eject	eject CDROM
create/mount ISO image	mkisofs mount -o loop pathToIso mountPoint	create/mount ISO image
ACL management	getfacl setfacl	ACL management
Fibre Channel / SAN	systool multipath	Fibre Channel / SAN
TASK \ OS	Linux	OS / TASK
NFS share definitions	/etc/exports	NFS share definitions
NFS share command	/etc/init.d/nfs-server reload (rh) exportfs -a	NFS share command
NFS information	cat /proc/mounts	NFS information
name resolution order	/etc/nsswitch.conf /etc/resolv.conf	name resolution order
show network interface info	ifconfig ethtool	show network interface info
change IP	ifconfig (rh) redhat-config-network (fedora) system-config-network (rh) edit: /etc/hosts, /etc/sysconfig/network, /etc/sysconfig/ network-scripts/ ifcfg-eth0 (deb) edit /etc/network/interfaces; /etc/init.d/networking restart	change IP
start DHCP client	dhcpcd dhclient	start DHCP client
ping one packet	ping -c 1 hostname	ping one packet
sniff network	etherfind tcpdump wireshark (formerly ethereal) etherape	sniff network
route definitions	route (rh) /etc/sysconfig/network (rh) /etc/sysconfig/static-routes (deb) /etc/init.d/network (deb) /etc/network	route definitions
telnetd, ftpd banner	/etc/issue.net (telnet) (ftp varies; can use tcp wrappers)	telnetd, ftpd banner
set date/time(from net: ntp or other)	ntpdate rdate netdate	set date/time(from net: ntp or other)
TASK \ OS	Linux	OS / TASK
auditing	(2.6+) auditd /var/log/faillog	auditing
encrypted passwords in	/etc/shadow (may vary)	encrypted passwords in
min password length	/etc/pam.d/system-auth	min password length
allow/deny root logins	/etc/securetty	allow/deny root logins
firewall config	iptables ipchains ipfwadm (rh) redhat-config- securitylevel	firewall config
TASK \ OS	Linux	OS / TASK
show installed software	(rh) rpm -a -i (rh) rpm -qa (rh) yum list installed (deb) dselect (deb) aptitude (deb) dpkg -l (gen) ls /var/db/pkg/* (gen) eix -I	show installed software
file is in which package	(deb) dpkg --search file (deb) apt-file update && apt-file search file (rh) rpm -qif file (gen) equery b file (gen) qfile file	file is in which package
add software	(rh) rpm -hiv (rh) yum install pkg (deb) dselect (deb) apt-get install pkg (deb) dpkg -i (md) urpmi	add software
precompiled binaries of GPLware and freeware	www.linux.org linux.tucows.com sourceforge.net rpmfind.net (deb) ftp.debian.org (deb) packages.debian.org (gen)packages.gentoo.org3 (gen)gentoo-portage.com3 (md)easyurpmi.zarb.org	precompiled binaries of GPLware and freeware
C compiler	cc gcc	C compiler
show patch level and/or patches	(rh) rpm -q (rh) cat /proc/version (rh) cat /etc/redhat-release (deb) dpkg -s	show patch level and/or patches
patch tool	apt-get update apt-get upgrade (rh) up2date (rh) yum update (md) urpmi	patch tool
configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html	ldconfig ldd lsmod	configure/show runtime linking fortran-2000.com/ ArnaudRecipes/ sharedlib.html
link library path	$LD_LIBRARY_PATH /etc/ld.so.conf	link library path
tracing utility	strace ltrace	tracing utility
define user defaults	/etc/profile /etc/security/ /etc/skel/ /etc/profile.d/*	define user defaults
csh global .login	/etc/csh.login	csh global .login
default syslog and messages	/var/log/syslog /var/log/messages /usr/adm/messages /var/log/maillog	default syslog and messages
system error reporting tool	dmesg (deb) reportbug	system error reporting tool
performance monitoring	vmstat procinfo -D top htop pstree	performance monitoring
match process to file or port	lsof netstat -atup	match process to file or port
manage various logs	logrotate (rh)sysreport; sosreport	manage various logs
X pop-up	/usr/X11R6/bin/xmessage	X pop-up
Wikipedia	Linux	Wikipedia
FAQs (see also faqs.org)	www.linuxdoc.org/ FAQ/Linux-FAQ www.debian.org/doc/ FAQ	FAQs (see also faqs.org)
blogs	linuxmoz.com	blogs
mailing list	www.linumanagers .org www.linux.org/ help/lists.html	mailing list
mailing list archives	www.linuxmanagers.org/ pipermail/linuxmanagers lists.debian.org	mailing list archives
man pages www.freebsd.org/ cgi/man.cgi	www.linuxmanpages.com/ Fedora Core 4: linuxcommand.org/ superman_pages.php www.tldp.org/docs.html#man	man pages www.freebsd.org/ cgi/man.cgi
newsgroup(s) and forums groups.google	comp.os.linux.* (esp .answers)	newsgroup(s) and forums groups.google
user groups	www.debianhelp.org	user groups
magazines	www.linuxjournal.com www.linux-mag.com www.debianplanet.org	magazines
vendor home page	www.linux.org www.debian.org gentoo.orgwww.redhat.com (SUSE) www.novell.com/linux	vendor home page
vendor docs and patches (see also man pages)	tldp.org www.linuxdoc.org/ rpmfind.net/linux/RPM	vendor docs and patches (see also man pages)
vendor phone (US)	?	vendor phone (US)
wikis	fedoraproject.org/ wiki/Main_Page (fed) susewiki.org (SUSE)	wikis
TASK / OS	Linux	OS \ TASK