Labels

admin (1) aix (1) alert (1) always-on (2) Architecture (1) aws (3) Azure (1) backup (3) BI-DWH (10) Binary (3) Boolean (1) C# (1) cache (1) casting (3) cdc (1) certificate (1) checks (1) cloud (3) cluster (1) cmd (7) collation (1) columns (1) compilation (1) configurations (7) Connection-String (2) connections (6) constraint (6) copypaste (2) cpu (2) csv (3) CTE (1) data-types (1) datetime (23) db (547) DB2 (1) deadlock (2) Denali (7) device (6) dotNet (5) dynamicSQL (11) email (5) encoding (1) encryption (4) errors (124) excel (1) ExecutionPlan (10) extended events (1) files (7) FIPS (1) foreign key (1) fragmentation (1) functions (1) GCP (2) gMSA (2) google (2) HADR (1) hashing (3) in-memory (1) index (3) indexedViews (2) insert (3) install (10) IO (1) isql (6) javascript (1) jobs (11) join (2) LDAP (2) LinkedServers (8) Linux (15) log (6) login (1) maintenance (3) mariadb (1) memory (4) merge (3) monitoring (4) MSA (2) mssql (444) mssql2005 (5) mssql2008R2 (20) mssql2012 (2) mysql (36) MySQL Shell (5) network (1) NoSQL (1) null (2) numeric (9) object-oriented (1) offline (1) openssl (1) Operating System (4) oracle (7) ORDBMS (1) ordering (2) Outer Apply (1) Outlook (1) page (1) parameters (2) partition (1) password (1) Performance (103) permissions (10) pivot (3) PLE (1) port (4) PostgreSQL (14) profiler (1) RDS (3) read (1) Replication (12) restore (4) root (1) RPO (1) RTO (1) SAP ASE (48) SAP RS (20) SCC (4) scema (1) script (8) security (10) segment (1) server (1) service broker (2) services (4) settings (75) SQL (74) SSAS (1) SSIS (19) SSL (8) SSMS (4) SSRS (6) storage (1) String (35) sybase (57) telnet (2) tempdb (1) Theory (2) tips (120) tools (3) training (1) transaction (6) trigger (2) Tuple (2) TVP (1) unix (8) users (3) vb.net (4) versioning (1) windows (14) xml (10) XSD (1) zip (1)
Showing posts with label unix. Show all posts
Showing posts with label unix. Show all posts

netstat - network statistics

netstat is a command displays statistics on all network activities.


main options:

-a Displays all active ports

-n Numerical display of addresses and port numbers

-o Displays the process identifiers (PID)

| grep 11753 - displays information only for IP 11753 (or other filter)


netstat -a -n | grep 11753





SAP ASE (Sybase) - set environment variables from SYBASE.sh in Unix

. SYBASE.sh

(instead of 
source SYBASE.sh
)

AIX - CPU, memory and IO (disks space) commands

CPU usage for each process:
topas –P

CPU details:
mpstat

Memory details:
vmstat
svmon

Disk IO details:
iostat
topas -D 

Connect to isql

isql Uusername Ppassword [Sserver]

(U , P , S - as is and then replace to the user, password, ...)
( Pay attention: names are case-sensitive )

Unix/Linux zip commands

zip file: 
zip FILENAME.ZIP

unzip file: 
unzip FILENAME.ZIP

unzip to a folder: 
unzip FILENAME.ZIP -d FOLDERNAME

instsall zip:
sudo apt install zip

Unix/Linux files commands

remove a file
rm
(rm * - remove all files in the folder)
(-f - force deletion)

find a file in a folder including sub-folders by it's name:
find -name FILENAME
find a file in a folder including sub-folders by part of it's name:
find -name FILEN*

view text of a file
more FILENAME
  • Exit by pressing q key

edit a file
vi FILENAME
  • To save a file: press Esc key, type :w, Enter
  • To save a file and quit: press Esc key, type :x, Enter

grant privilege to a user
chown -R USERNAME: FOLDERNAME
(-R - to recursively operate on all files and directories under the given directory)

Unix/Linux System and enviroment commands

show enviroment parameters
env
show enviroment parameters results match a specified pattern
env | grep STRING

add parameter to env or replace exists value:
export PARAM="VALUE"
concantanete value to exists parameter in env:
export PARAM="VALUE":$PARAM

available and used disk space usage
df
(df -h - more human display)

Unix/Linux basic commands

where I am
pwd

go to FOLDERNAME folder
cd FOLDERNAME

go to parent folder
cd ..

display what is in the folder
ls
(-l all files)
(- la all include hidden)

create a folder
mkdir FOLDERNAME

display an user manual for a command
man COMMAND

switch user
su

run a command like admin (= "as administrator" in windows)
sudo COMMAND ...

desplay results that match a specified pattern
COMMAND | grep STRING

show commands history
history