The Hellespontos

TSM UPDATE PATH

2010-07-13T23:18:00.000-07:00

driver tsm tarafından gozukuyor olmasına rahmen tivolide gozukmuyorsa;
UPDATE PATH BOYDAKTSM DRIVE01 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 DEVICE=mt2.0.0.4 ONLINE=YES AUTODETECT=NO

veya
object view->server storage -> tape paths

q drive f=d
q path
q libr

aix aygıtların ayrıntıları

2010-05-21T22:59:00.000-07:00

lscfg -vpl fcs1

lsdev -C -c disk

lscfg -vl hdisk2
lsattr -E -l hdisk12

lslpp -l | grep mpio

storage pool
Maximum Scratch Volumes Allowed
--------------
snap gbc

snap -ar
snap -ac

BR0971W The default temporary tablespace of database sid is set to SYSTEM

2010-04-15T07:00:00.000-07:00

BR0971W The default temporary tablespace of database is set to SYSTEM

cozum;

select username,temporary_tablespace from dba_users

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

SAP se14 partitioning

2010-04-08T05:45:00.000-07:00

-se14
-tablo edit
-storage parameter
-for new creation
partition ekliyoruz.
-extact-force

SAP db16 table

2010-03-30T04:10:00.001-07:00

select * from SAPSR3.DBMSGORA where SAPSR3.DBMSGORA.time like '20100316%' and severity='E'

select * from SAPSR3.DBCHECKORA

select * from SAPSR3.DBDIFF

Solaris zoneadm ve security, websites oracle

2010-03-30T04:07:00.000-07:00

http://blogs.sun.com/menno/entry/faster_zone_provisioning_using_zoneadm
http://www.mernin.com/blog/?p=68

more /etc/security/login.cfg

http://wikis.sun.com/display/SAPonSun/Running+SAP%27s+Java+Gui+on+OpenSolaris+%28sort+of%29

http://www.wiziq.com/online-tests/9296-sap-basic-installation-on-unix-oracle-data-base-test-2
http://www.oracle-base.com/articles/10g/Auditing_10gR2.php
http://www.akadia.com/services/ora_linux_install_10g.html

http://unix.ittoolbox.com/groups/technical-functional/unixadmin-l/script-to-automate-sending-of-alertnotification-of-filesystem-utilization-3187954
http://www.unix.com/unix-dummies-questions-answers/36228-aix-send-mail-html-message-body-binary-attachment.html
http://www.oracle.com/technology/oramag/code/tips2004/060704.html
http://www.praetoriate.com/oracle_tips_alert_scripting.htm
http://ipucu.enderunix.org/view.php?id=44&lang=en
http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1266486022084+28353475&threadId=1027646
http://forums.sdn.sap.com/message.jspa?messageID=6864807
http://www.oracle.com/technology/oramag/code/tips2005/index.html
--------------------------------------------
http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/toc.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm
http://kb.dbatoolz.com/tp/2693.create_oracle_10gr2_standby_database_using_real_time_apply.html

http://www.dbasupport.com/forums/showthread.php?t=58129
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1027411
http://www.dba-oracle.com/t_oracledataguard_235_dba_logstdby_.htm

http://www.oracle.com/technology/obe/obe9ir2/obe-ha/dataguard/dg.htm#10

broker
http://www.dbasupport.com/oracle/ora11g/11gDataGuard_02.shtml
--http://www.ritzyblogs.com/OraTalk/EntryId/122/How-to-setup-DGMGRL-broker-with-example

http://www.dba-oracle.com/t_password_security.htm sec

solaris format komudu örnek

2010-03-30T03:49:00.000-07:00

format -e c1t2d0
295 zfs list
296 zpool add -f rpool c1t2d0s0
297 prtvtpc /dev/rdsk/c1t0d0s0 | fmthard -s - /dev/rdsk//c1t2d0s0
298 prtvtoc /dev/rdsk/c1t0d0s0 | fmthard -s - /dev/rdsk//c1t2d0s0
299 zpool attach rpool c1t0d0s0 c1t2d0s0
300 zpool attach -f rpool c1t0d0s0 c1t2d0s0
301 format
302 format
303 format
304 format
305 zpool attach -f rpool c1t0d0s0 c1t2d0s0
306 installgrub -m /boot/grub/stage1 /boot/grub/stage /dev/rdsk/c1t2d0s0 -- iptal
307 installgrub -m /boot/grub/stage1 /boot/grub/stage2 /dev/rdsk/c1t2d0s0
308 zpool status
309 historyq

zpool detach rpool c1t2d0s0
----------------------
uname -r
pkginfo -i
showrev -p

aix send mail

2010-03-30T03:47:00.000-07:00

cat /tmp/t/mailheader /tmp/t/mailbody | /usr/lib/sendmail -t

uuencode /tmp/text.txt | mailx -s "my report" ferhan@tekin.com

mail TEST

SAP - Oracle parameters sapnotes

2010-03-30T02:43:00.000-07:00

830576 oracle - sap parameter
1171650
1289199
926023 security
709756
Note 619188 - FAQ: Oracle wait events

IBM Storage fw geçilmesi

2010-03-03T05:44:00.001-08:00

ILK OLARAK STORAGE ILE BIRLIKTE GELEN CD NIN IÇINDEKI STORAGE MANAGER I KURUYORUZ. PROGRAMI AÇTIĞIMIZDA OTOTAMTIK OLARAK STORAGE TARATIYORUZ. DIKKAT EDILMESI GEREKEN NOKTA STORAGE ILE MAKINA AYNI NETWORK TE OLMALIDIR. STORAGE BULDUKTAN SONRA SAĞ TIKALYIP MANAGE DIYORUZ. ARAÇ CUBUĞUNDAN ADVANCED – MAINTAINCE DEDIĞIMIZDE HANGI FW I GEÇEĞIMIZI ISTEYECEĞI MENULER CIKIYOR. ILK ÖNCE DISKLERI SONRA CONTROLLER FW GECMEMIZ DAHA DOGRU OLUR. BU ESNADA STORAGE ILE BILI ALIŞ VERIŞI OLMAMASI GEREKMEKTEDIR. FW GECECEĞIMI DOSYALARI IBM SUPPORT SITESINDEN STORAGE MODELINI YAZARAK TEMIN EDIYORUZ.SON VERSION 07.60.28 OLARAK GUNCELLENDI.

SAP kernel upgrade

2010-02-12T22:19:00.000-08:00

sidadm> stopsap
su - root
cd sapmnt
sapmnt> cp -pr exe exe_old
cd /usr/sap/trans/kernel_yeni
SAPCAR -xvf SAPEXE_236-20001810.SAR
SAPCAR -xvf SAPEXEDB_236-20001829.SAR
SAPCAR -xvf tp_239-20001810.sar
SAPCAR -xvf lib_dbsl_241-20001829.sar
testadm> rm SAPEXE_236-20001810.SAR
testadm> rm SAPEXEDB_236-20001829.SAR
testadm> rm tp_239-20001810.sar
testadm> rm lib_dbsl_241-20001829.sar
root
sapmnt>cd exe
>rm -Rf *
cp -pr /usr/sap/trans/kernel_yeni/* /sapmnt/BMI/exe/
ls -lrt
sapmnt>
cp -pr exe_yedek/saproot.sh exe/
cd exe
bash-3.00# ksh saproot.sh BMI
saproot.sh[122]: whoami: not found
saproot.sh[122]: test: argument expected
Preparing saposcol ...

Preparing icmbnd ...
done
------------
sm51 den release note deyip sondurumu bakabilirsiniz
----------
diger sistem için
test2adm> pwd
/sapmnt/BMT
test2adm> ls
exe global kernel_yeni profile
test2adm>
test DE OLUŞTURULAN KERNEL_YENİ KLASORU /SAPMNT/ İÇERİSİNE KOPYALANDI. ADI EXE OLARAK DEĞİŞİTİRİLDİ.

Solaris xterm ile bağlantı ve locale ayarları

2010-02-11T03:59:00.000-08:00

chmod 777 /usr/openwin/lib/X11/fontserver.cfg
ex path: /usr/bin/:/usr/dt/bin:/usr/openwin/bin:/usr/ucb

ssh -X -l root ip
DISPLAY=:0.0
export DISPLAY
xclock
--------------
locale
LC_ALL
vim /etc/defaults/locale
locale -a
localedef -v -c -i en_US -f UTF-8 en_US.UTF-8
localedef -i en_US -c -f UTF-8 en_US.UTF-8
$HOME/.profile or
$HOME/.cshrc
LANG=C
LC_ALL=C -- c asci

Example from the /etc/default/init file:

SAP organization level ekleme

2010-02-10T06:29:00.000-08:00

se38
PFCG_ORGFIELD_CREATE

Solaris'de IP aliasing - Bir ethernet kartina birden fazla IP verm

2010-02-10T06:26:00.000-08:00

Solaris'te IP aliasing yapmak icin:

# ifconfig arabirim:N plumb
# ifconfig arabirim:N IP_ADRESİ netmask NETMASK up

N: 1 den buyuk ve izin verilen en fazla yalanci aygit sayisindan kucuk bir sayi(solaris 2.6 ve onceki versiyonlarda 255)
ornek: ce0 ethernet arabirimi icin 192.168.1.1 IP adresini 2. IP olarak eklemek icin:

# ifconfig ce0:1 plumb
# ifconfig ce0:1 192.168.1.1 netmask 255.255.255.0 up

Degisikligin her acilista etkinlesmesi icin
/etc/hosts dosyasina asagidaki gibi kayit eklenir.
192.168.1.1 host_adi

/etc/hostname.ce0:1 dosyasi olusturup icerisine
host_adi
yazilir
# cat /etc/hostname.ce0:1
host_adi
#

SAP parola değiştirme ve os den db bağlantı

2010-02-10T06:19:00.001-08:00

R3trans baglantisini test edilmesi
R3trans -x

sapsr3 parola degistirme
brconnect -u / -f chpass -o sapsr3 -p password
--------------------------
işletim sisteminde database bağlantı yapma;
DROP TABLE OPS$sidADM.SAPUSER CASCADE CONSTRAINTS;

CREATE TABLE OPS$sidADM.SAPUSER
(
USERID VARCHAR2(255 BYTE),
PASSWD VARCHAR2(255 BYTE)
)
TABLESPACE SYSTEM
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

--DROP SYNONYM OPS$SAPSERVICEsid.SAPUSER;

CREATE SYNONYM OPS$SAPSERVICEsid.SAPUSER FOR OPS$sidADM.SAPUSER;

GRANT INSERT, SELECT, UPDATE ON OPS$sidADM.SAPUSER TO OPS$SAPSERVICEsid;

SAP tp ile request taşıma

2010-02-10T06:02:00.000-08:00

request cofile ve datafile a taşınıyor
tp addtobuffer request SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL
tp SETTRANSFERRED ALL SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL REMOTE=SID2 -Dtransdir=/usr/sap/trans
tp import request SID U client=900 pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL
--yok tp TRANSMITBUFFER SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL REMOTE=SID2 -Dtransdir=/usr/sap/trans

SAP Support Package installation

2010-02-10T04:49:00.000-08:00

Basis Plug-In (PI_BASIS) 2006.1
sap note:1007796

Aix to Solaris nfs mount

2010-02-05T06:15:00.000-08:00

aix makinada
/etc/exports dosyasina;
/test -sec=sys:krb5p:krb5i:krb5:dh,rw,root=solaris_hostname

usr/sbin/exportfs -a yi calıştırıyoruz.

solaris makinada
/etc/filesystems/

/test2:
dev = "/test"
vfs = nfs
nodename = aix_hostname
mount = false
type = sap_nfs
options = rw,bg,soft,intr,sec=sys
account = false

/etc/default/nfs
client version 3 olacak
sonra;
mount aix:/test /test2
client version hemen set olmazsa;
mount -F nfs -o vers=3 aix:/test /test2

SAP smtp problem

2010-01-26T03:11:00.000-08:00

scot ile giriyoruz setting/default domain girdikten sonra kontrol edebilirsiniz!
ilgili işlem kodları:SU01D and SCOT and SOST

solaris

2010-01-21T05:43:00.001-08:00

devfsadm
format
format
Searching for disks...done

AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c2t0d0
/pci@0,0/pci15ad,1976@10/sd@0,0
2. c2t1d0
/pci@0,0/pci15ad,1976@10/sd@1,0
3. c2t2d0
/pci@0,0/pci15ad,1976@10/sd@2,0

zpool create fpool mirror c2t0d0 c2t1d0
df -h /fpool
zfs create fpool/fs
zpool list
zfs set mountpoint=/fs /fpool/fs
zpool offline fpool c2t0d0
zpool status -v fpool
zpool replace fpool c2t0d0 c2t2d0
ex:
# zpool offline rpool c1t0d0s0
# cfgadm -c unconfigure c1::dsk/c1t0d0
# cfgadm -c configure c1::dsk/c1t0d0
# zpool replace rpool c1t0d0s0
# zpool online rpool c1t0d0s0

zpool attach fpool c2t2d0 c2t0d0
zpool detach fpool c2t2d0

zpool add fpool spare c2t2d0

zpool replace fpool c2t1d0 c2t2d0 --disk1 bozuldu
zpool remove fpool c2t2d0

zpool get all fpool

Solaris Zone network ayari

2010-01-21T00:30:00.000-08:00

1. Via zonecfg:
zonecfg -z zone1
add net
set physical=e1000g0
set address=192.168.80.151
end
verify
commit

2. Via ifconfig:
ifconfig e1000g0:1 plumb 192.168.80.151 netmask + broadcast + up
ifconfig e1000g0:1 zone zone1

ilkinde zone u restart etmek gerekcek. fakat ikincisinde gerek yok.

Solaris Zone olusturma

2010-01-20T23:07:00.000-08:00

# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs create -o canmount=noauto rpool/ROOT/s10x_u8wos_08a/zones
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones
# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/ROOT/s10x_u8wos_08a/zones 21K 2.66G 21K /zones
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones
# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/ROOT/s10x_u8wos_08a/zones 21K 2.66G 21K /zones
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs create -o canmount=noauto rpool/ROOT/s10x_u8wos_08a/zones/test1
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones/test1
# zonecfg -z test1
test1: No such zone configured
Use 'create' to begin configuring a new zone.
zonecfg:test1> create
zonecfg:test1> set zonepath=/zones/test1
zonecfg:test1> set autoboot=true
zonecfg:test1> add net
zonecfg:test1:net> set physical=e1000g0
zonecfg:test1:net> set address=192.168.80.141
zonecfg:test1:net> end
zonecfg:test1> verify
zonecfg:test1> commit
zonecfg:test1> exi
# chmod 700 /zones/test1
# zoneadm -z test1 verify
# zoneadm -z test1 verify
# zoneadm -z test1 install
Preparing to install zone .
Creating list of files to copy from the global zone.
Copying <7513> files to the zone.
Initializing zone product registry.
Determining zone package initialization order.
Preparing to initialize <1124> packages on the zone.
Initialized <1124> packages on zone.
Zone is initialized.
The file contains a log of the zone installation.
# zoneadm list -c
global
testzone
zone1
test1
# zoneadm list -cv
ID NAME STATUS PATH BRAND IP
0 global running / native shared
- testzone incomplete /testpool/home/test1 native shared
- zone1 incomplete /testpool/zones/zone1 native shared
- test1 installed /zones/test1 native shared
# zoneadm list -iv
ID NAME STATUS PATH BRAND IP
0 global running / native shared
- test1 installed /zones/test1 native shared
# zoneadm -z test1 ready
zoneadm: zone 'test1': WARNING: e1000g0:1: no matching subnet found in netmasks(4) for 192.168.80.141; using default of 255.255.255.0.
# zoneadm -z test1 boot
# zlogin -C -e \# test1
turkiye utf seçtim
cde
geri kalanlar default2
dns yok.
#zlogin test1

sap parametrelerine işletim sistemi üzerinden bakma

2010-01-04T03:39:00.000-08:00

sappfpar all

sappfpar check pf=WRP_D00_WERPPROA

SAP EarlyWatch Alert

aix komutları -2

2010-01-04T03:33:00.001-08:00

lssrc -s nimsh --servis bilgileri
ipcs -ma --shared memory bilgileri

tail -f /var/hacmp/log/hacmp.out

vi .bash_profile

tivoli tsm sorguları

2010-01-04T03:23:00.001-08:00

QUERY ACTLOG BEGINDATE=12/25/2009 BEGINTIME=NOW-1:00 ENDDATE=12/26/2009 ENDTIME=NOW ORIGINATOR=ALL

QUERY SESSION

QUERY EVENT * * BEGINDATE=12/25/2009 BEGINTIME=00:00 ENDDATE=12/26/2009 ENDTIME="08:02:14 "

select
volume_name as dbbackup from volhistory where type='BACK-
UPFULL' and devclass='LTO'

select
stgpool_name,count(*) as "toplam adet" from volumes where
devclass_name='LTO' group by stgpool_name order by 1

select count(*) as Scratch_adedi from libvolumes where status='Scratch'

select
count(*) as Lib_Kartus_sayisi from libvolumes

select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Missed')))

select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Failed')))

select
nodename,substr(char(date_time), 1, 16) as "TME",message
from actlog where (msgno=4005 or msgno=4007 or msgno=4018
or msgno=4037 or msgno=4987) and (date_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
nodename

select
substr(char(date_time), 1, 16) as date_time,message from
actlog where (date_time between '2009-12-22 08:00:00' and
'2009-12-23 07:59:59') and severity<>'I'

select
entity,activity,bytes as BYTES from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
bytes desc

select node_name,platform_name,client_os_level,client_version,c-
lient_release,client_level,client_sublevel from nodes
where node_name in (select entity from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59'))

lob segment shrink

2010-01-04T03:19:00.001-08:00

https://forums.sdn.sap.com/thread.jspa?threadID=1414229&messageID=7891933

https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=821687
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1319517
https://websmp130.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1010237

ESBIGTBL Tablespace is Growing More Than a Giga Per Day [ID 331534.1]

select owner, table_name, column_name from dba_lobs
where segment_name = 'SYS_LOB0000080468C00006$$'

select * from SAPSR3.tst03

SYS_LOB0000080468C00006$$

tst03 112
lob -3.25

alter table SAPSR3.TST03 disable row movement;

alter table SAPSR3.TST03 shrink space cascade;

select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
----------------------------------------------
SOFFCONT1.SYS_LOB0000068056C00007$$ 64G
RSBCS_REORG
RSDBDEOC
SO30 trans (RSBCSRE03 report)

14,4 08.20 GSYS_LOB0000076186C00006$$

alter table SAPSR3.TST03 enable row movement;
alter table SAPSR3.TST03 shrink space cascade;
alter table SAPSR3.TST03 enable row movement;

select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'

SOFFCONT1
so30
RSBCS_REORG
RSSOCVPC

RSSORE00
RSCBCSRE03
RSBCSRE03

ALTER TABLE SOFFCONT1 MODIFY LOB (CLUSTD) (SHRINK SPACE);

select owner, table_name, column_name from dba_lobs
where table_name='SOFFCONT1'
brspace -c force -p initsid.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t TST03
-------------
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool shrink_list
select 'brspace -c force -p initBP3.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t '||table_name from user_tables;
spool off
---------------
http://forums.sdn.sap.com/thread.jspa?threadID=338689

1. Run RSSO_DELETE_PRIVATE - I have run these for Document class RAW and OTF.
2. Run RSSODFRE
3. Run RSBCS_REORG - I have run these for Document class RAW and OTF.

This will delete and clean-up SOC3 and SOFFCONT1.
SOFFCONT1 stores any reports sent thru SAP office / workplace.

crontab

2010-01-04T03:16:00.001-08:00

http://www.bilgipasaji.com/forum/hosting-genel-bilgi-395/46206-cron-jobs-kurulumu-ayarlari-kullanimi.html

sap portal açılış adımları

2010-01-04T03:10:00.001-08:00

JdbcCon.log
/home/bpdadm/startdb.log

/home/bpdadm/startsap_SCS01.log

/home/bpdadm/startsap_JC00.log

error 0516-787 extendlv: Maximum allocation for logical volume

2010-01-04T03:09:00.000-08:00

: 0516-787 extendlv: Maximum allocation for logical volume ... is 512

permalink
chlv -x 1000

brbackup, brspace datafile boyutu resize

2010-01-04T03:00:00.000-08:00

brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_27/sr3.data27' -s 11500M
alter database datafile '/oracle/SID/sapdata4/sr3_27/sr3.data27' resize 11500M

brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_30/sr3.data30' -s 14500M

ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' RESIZE 10240M;
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' AUTOEXTEND ON NEXT 500M MAXSIZE 10240M;

---------------------------
brbackup -u system/***** -c -m all -t online

./nbackint -p /utl/ -f password -- yedekleme kartuj sistemi ile bağlantı

backint -p D:\oracle\%ORACLE_SID%\102\database\init%ORACLE_SID%.utl -f password

brbackup -u system/manager -c -m all -t offline_force
brarchive -u system/manager -c force -sd

-p initBPD2.sap -d disk
-t online -m all -k no -e 0 -l E

-p initBPD.sap -d util_file_online -r initBPD.utl
-t online -m all -k no -l E

-p initBPD.sap -d util_file_online -r initBPD.utl -t online -b -d -m all -k no -l E

sap oracle bağlantısı testi

2010-01-04T02:59:00.001-08:00

startsap options:
# startsap - starts r3 and database.
# startsap db - starts only the database.
# startsap r3 - starts r3 and assumes that the database is already started.

Stopping of an R/3 uses the file stopsap.
http://myadmin.wordpress.com/2007/01/29/startsap-what-is-behind-it/

R3trans -x sap database bağlantı sağlyabiliyormu
http://help.sap.com/saphelp_40b/helpdata/pt/3d/ad5ca44ebc11d182bf0000e829fbfe/content.htm

http://www.tech-recipes.com/rx/569/some-common-aixunix-commands/

aix shell conf

2009-11-09T07:20:00.001-08:00

stty
speed 9600 baud; -parity
erase = ^?; eol = ; eol2 =
brkint -inpck -istrip icrnl onlcr tab3
echo echoe echok
$ stty erase "BackspaceKey"
$ stty erase '^H'
$ stty
speed 9600 baud; -parity
eol = ; eol2 =
brkint -inpck -istrip icrnl onlcr tab3
echo echoe echok

http://users.ca.astound.net/baspence/AIXtip/index.html

http://it.toolbox.com/blogs/my-two-cents/customizing-aix-prompt-32801$LOGNAME'@'$(hostname)':$PWD >'

set prompt="`uname -n`:`whoami` \!> "

.kshrc
> # configuring ksh for use with Emacs tramp
> unset HISTFILE
> unset HISTSIZE
> /bin/rm $HOME/.sh_history
http://www.mail-archive.com/emacs-rcp@ls6.cs.uni-dortmund.de/msg02448.html

SAP perf analiz

2009-11-09T05:21:00.000-08:00

CPU
sar, vmstat, mpstat, iostat

Memory
sar, vmstat

Disk
sar, iostat

Network
netstat

BR1049W Not enough free space in /oracle/sid/sapdata5/sr3_63
for total maximum size of all database files of tablespace PSAPSR3
located on this disk volume, missing at least 272.222 MB
-------------------------------

"Knowledge is power, but it is only useful if it is shared!"

A sample backup schedule might look like:
1. Hourly - brarchive backup of archive logs
2. Daily - brbackup backup of full database
3. Monthly - file system backup of /sapmnt/, including SAP executables and profile data, and /oracle/SID/_/dbs & network ---making sure you get Oracle/SAP init files and network files (tnsnames.ora, listener.ora,\nnames.ora, etc., though you might have relocated these files elsewhere), & /usr/sap/trans directory.
4. Quarterly - Oracle export performed to tape.

This schedule is good enough for a small system landscape with an orgnanization. If the landscape is huge, then you need to re-think about how backup is done. An integration with Oracle RMAN is good for running incremental backup. This will reduce the number of media needed for running daily full online backup - storage optimization

--------------------------------
Authorization data administrator
Authorization profile administrator
User administrator
System administrator
Database administrator
Customizing project member
ABAP developer
Workplace end user

-----------------------------------
SAP gives you standard Basis role :

SAP_BC_BASIS_ADMIN
SAP_BC_DB_ADMIN or SAP_BC_DB_ADMIN_ORA if you are using Oracle
SAP_BC_CLIENTCOPY
SAP_BC_BATCH_ADMIN
SAP_BC_TRANSPORT_ADMINISTRATOR
SAP_BC_SPOOL_ADMIN

copy that to ZSAP_BC_BASIS_ADMIN, ZSAP_BC_DB_ADMIN, ZSAP_BC_DB_ADMIN_ORA, etc. then modify that Zrole if you need to add or remove tcode and/or authorization objects. and finally assign to your consultant username.

but you have to monitor your consultant for what they did on your production server using STAD.

----------------------

#grep MemTotal /proc/meminfo - Fiziksel Ram
#grep SwapTotal /proc/meminfo - swap
#df -k /tmp - /tmp dizinindeki boş disk
#df -k - Sistemdeki boş disk alanını
# cat /etc/issue - Linux’un versiyon ve distributionu
$ rpm -q package_name - Gerekli paketlerin kurulup kurulmadığını
# uname –r -Gerekli kernel versiyonu
kernel;
Parametre Değer Dosya
semmsl semmns semopm semmni 250 32000 100 128 /proc/sys/kernel/sem
shmall 2097152 /proc/sys/kernel/shmall
shmmax Fiziksel hafızanın yarısı (bytecinsinden) /proc/sys/kernel/shmmax
shmmni 4096 /proc/sys/kernel/shmmni
file-max 65536 /proc/sys/fs/file-max
ip_local_port_range 1024 65000 /proc/sys/net/ipv4 /ip_local_port_range

semmsl, semmns, semopm, semmni #/sbin/sysctl -a | grep sem
Bu komut semaphore parametrelerin değerlerini
sıralı bir şekilde listeler
shmall, shmmax,shmni #/sbin/sysctl -a | grep shm
file-max #/sbin/sysctl -a | grep file-max
ip_local_port_range #/sbin/sysctl -a|grep ip_local_port_range
------------------------
-- Herhangi bir text editor ile, /etc/sysctl.conf ya edit edin yada yaratın ve
aşağıdaki satırları ya ekleyin yada düzeltin:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
/etc/sysctl.conf dosyasını değistirdiksen sonra, bu değerler sisteminizi reboot
ettikten sonra aktif hale gelecektir.
SUSE sistemleri için, aşağıdaki komutu sistemin reboot olduktan sonra
/etc/sysctl.conf dosyasını okuyabilmesi için giriniz
#/sbin/chkconfig boot.sysctl on

• dba sistem grubunun yaratılması
# groupadd dba
• oracle kullanıcısının yaratılması
#useradd –s /usr/bin/ksh –g dba –d /home/oracle –m oracle

Shell limitlerini artırmak için
-- Aşağıdaki satırları /etc/security/limits.conf dosyasına ekleyin:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

mkdir –p /…/app/oracle/product/10.1.0
chown -R oracle:dba /…/app

root kullanıcısı olarak xhost + komutunu çalıştırın
# xhost +
# su - oracle
Xwindow uygulamasının açılıp açılamadığını kontrol etmek için
xclock yada xcalc uygulamalarını çalıştırın.
Red Hat:
# mount /mnt /cdrom
SUSE :
# mount /media/cdrom

---------------------------------------
abap/buffersize : Program Buffer Size
500MB 000 1500MB 000 kb
enque/table_size
16384 96MB 000
ipc/shm_psize_10
150MB 000 000 600MB 000 000
ipc/shm_psize_40 Size of shared memory segment
124MB 000 000 250MB 000 000 byte

RSPLSE
enque/table_size or abap/shared_objects_size_MB

You can check in transactions after executing your planning functions
1. SM12 : give table name RSPLS_S_LOCK
2. SHMA: give area name as CL_RSPLS_ENQ_AREA for table RSPLS_S_LOCK_SYNC
3. LC10 : for table LCA_GUID_STR
-----------------------------------------------
ALTER DATABASE DATAFILE 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

table;
begin
dbms_stats.gather_table_stats(ownname=> 'SAPSR3', tabname=> 'Ztable', partname=> NULL);
end;

index;
begin
dbms_stats.gather_index_stats(ownname=> 'SAPSR3', indname=> 'Zindex', partname=> NULL);
end;

check;
Parameters: -u / -jid CHECK20090806083734 -c -f check
statistics;
Parameters: -u / -jid STATS20090806084249 -c -f stats -t ALL
brconnect -u / -jid STATS20090806084249 -c -f stats -t ALL

--------------------------------
RSORADLD
ora102
IF ora_release < 'ORA732'. "#EC PORTABLE
MESSAGE e524. "Check only availible for Oracle release > 7.3
SET SCREEN 0. LEAVE SCREEN.
ENDIF

http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/toc.htm
--------------------
tu02 initSID.SAP
al11
-----------------------------------------

SAP Basis Course

2009-11-09T05:05:00.002-08:00

Title: SAP BASIS Consultant/ Trainer
Company: LAVIOT
Location: Any where from India
Salary: 200$ per head
Job Type : Part Time
Experience : 2 To 15+ Years

Job Description: The consultant should have hands on experience on SAP BASIS with atleast 3 to 8 years of experience.Job is purely part time. Who ever are interested and passionate about training
people can apply.Everything is online and no need to travel.You can sit at your home and just train.Follow are the contents are

SAP - BASIS ADMINISTRATION - COURSE CONTENT
SAP Basis Administration Training – R/3 with Oracle
• Orientation & Introductions
• SAP R/3,
• What is SAP R/3, New dimension Technology?
ERP Market Place
SAP AG
Overview of R/3, New dimension Technology?
R/3 Components
What is Basis?
R/3 Architecture & Technology
Basis Consultant’s Roles & Responsibilities
Get your hands dirty!
Introduction to Operating Systems – Unix and Windows 2000 Server
Introduction to RDBMS - Oracle
Introduction to R/3 Networking/Communications
Basic Architecture & Technology Concepts
Navigating SAP R/3
Logging On and Off
Graphical User Interface
On-line Help
Starting the R/3 System
Starting an R/3 Instance
Process Overview at the Operating System Level
Assigning Parameter Values R/3 Startup Logs and Traces
Startup Diagnostics
Database Startup Logs and Traces
Before Stopping the R/3 System
Stopping the R/3 System
Stopping R/3: Error Diagnostics
Transaction RZ10:
Profile Maintenance
R/3 Profiles
Maintaining R/3 Profiles
Changing R/3 Profile Parameters
Checking and Comparing R/3 Profiles
Operation Modes:
Concept
Choosing an Operation Mode
Choosing an Operation Mode

Setting Up Operation Modes/Instances
Adapting Instance Definitions and Operation Modes
Operation Mode Switch: Advantage
Scheduling Operation Modes
Switching Operation Modes Manually

Background Processing:
Background Processing
Why Background Processing?
What is a Background Job?
Scheduling of Jobs and Workload Balancing
Defining a Job Using the Job Wizard
Executing Programs as Job Steps
Start Conditions of a Job
Definition and Triggering of Events
Status of a Job
Summary Q & A
SAP R/3 Installation Concepts
Elements in R/3 Installation
Installation Steps
Installation of Presentation Server
Post-installation Steps
R3SETUP and INSTGUI Utilities
Client Instance Strategy
Terminology
Promote to Production Strategies
• Computer Center Management System
Overview of CCMS Concept
Managing Profiles
R/3 Operation Modes
CCMS Monitors
Managing SAP System Alerts
Database Performance Monitor
Operating System Performance Monitor
• Transport Management System
• Workbench/Customizing Organizer
Transports System Concepts
System Types
Using tp, the Transport Control Program
Post Installation Steps
• Database maintenance and architecture
Oracle and SAP R/3
Introduction to BRTOOLS
Table space Administration with BRTOOLS
• SAP Online Support System (OSS)
• SAP Database Administration – Continued\
Backing Up the Database: BRBACKUP
Backing Up the Archived Redo Logs: BRARCHIVE
• R3 Performance tuning
• Management of Users, Authorizations and
Overview of User Administration
Managing User Master Records
• SAP Printing System
• General Admin Utilities
Monitoring User Sessions
Monitoring Work Processes
Monitoring Update Records
Monitoring Lock Entries
Monitoring Client Copies
R/3 System Logs
ABAP/4 Short Dumps
System Traces
SAP Installation – 4.7 and ECC 5.0
a) SQL Installation
b) Service Packs
c) Central Installation
d) Database Installation
Application Server Installation
a) SQL Client Installation
b) SAP Dialogue Installation
Post Installation
a) Check Installation
b) Client Creation
c) Client Copy
d) Add Logical System
e) STMS Configuration
f) Operation Mode
g) Kernel and Patches update
h) Profile changes
User Administration
a) User Creation
b) User Lock/Unlock/Change Password
c) Kill Users
d) Authorization to Users
e) Send Message to Users (Single & Multiple)
Change Request
a) Create CR
b) Release CR
c) Transport CR
d) Merge CR

Authorization/Security
a) Create Role
b) Copy Role
c) Remove Role
d) Add or Remove TCode to Role
e) Add or Remove Object to Role
Job Scheduling
a) Schedule a Job
b) Monitor a Job
c) Delete a Job
Printer
a) Create a Printer
b) Create a local Default Printer
c) Create a Network Printer
d) Attach a Network Printer to a Role
e) Create Cheque Printer
Transport
a) Import CR
b) Transport CR
c) Transport Role
Client
a) Client opening or closing
SAP Market
a) Request/Applying and Status of License Key
b) Generate Developer Access Key
c) Open a Problem via SAP Market Place
d) Download Support Package – SPAM
e) Download Kernel Patches
f) Send Messages to SAP
SMTP Connecter
a) Add an SMTP Connector
b) Modify/Delete Connection
RFC Connection
a) Create RFC Connection
b) Modify/Delete Connection
Background Job
a) Create Background Jobs
b) Modify/Monitor Jobs
Monitoring
a) Global Work Process
b) Work Process
c) Work Loading System
d) Backup
e) Lock Entries
f) Updates
g) Errors
h) Consistency Check
i) Temese Check
j) Memory/CPU Management
Performance Tuning
a) Archiving
ITS Installation
Trouble Shooting
a) SAP System Response Trouble Shooting
b) SAP System Startup Trouble Shooting
c) SAP GUI Trouble Shooting
d) SAP Printer Trouble Shooting
Operation Mode Maintenance
Profile
CCMS
Backup & Recovery
• Typical Basis tasks
Daily
Weekly
Monthly
Q & A
------------------------
Oracle/SAP Database Administration
• DBA tools provided by SAP
• BR*Tools (GUI)
• BR*Tools Studio (web-based)
• DBA Cockpit
• DBA tools provided by Oracle
• Oracle Enterprise Manager / DB
-------------------------------
Egıtım ıcerıklerı asagıdakı gıbıdır

Oracle Mimarisi
System Admin Advanced Level
Data Guard for Oracle
Disaster for Oracle
Performans Tuning for Oracle
Backup for Oracle
Oracle on SAP
---------------------------------

SAP Basis Course

2009-11-09T05:05:00.001-08:00

SAP role menu

2009-11-09T01:55:00.000-08:00

roledeki menuleri bulma;
select * from(
select t1.mandt, t1.agr_name,t1.parent_id,t1.object_id,t1.report ,t2.text,menu_level
from AGR_HIER t1, agr_hiert t2
where
t1.mandt=t2.mandt and t1.mandt='3'
and t1.object_id=t2.object_id
and t2.spras='T'
and t1.agr_name=t2.agr_name and t1.agr_name like 'Z_%' and
t1.agr_name not like 'ZALL%' and t1.agr_name not like'Z%'
--and report='MM03'
order by agr_name, parent_id , object_id) A1

group by parent_id

and parent_id=1
order by object_id
--and spras='T'

----------------------------------------
---------------------------------------------------
select * from(
select t1.mandt, t1.agr_name,t1.parent_id,t1.object_id,t1.report ,t2.text,menu_level
from AGR_HIER t1, agr_hiert t2
where
t1.mandt=t2.mandt and t1.mandt='300'
and t1.object_id=t2.object_id
--and t2.spras='T'
and t1.agr_name=t2.agr_name and t1.agr_name like 'Z:1000_%' and t1.agr_name like 'Z:1000_ELT%' and
t1.agr_name not like 'Z:1000_ALL%' and t1.agr_name not like'Z:1000%'
--and report='MM03'
order by agr_name, parent_id , object_id) A1 ,(select agr_name,object_id,text from AGR_HIERt
where mandt='700'
and agr_name like 'Z:%'
order by object_id) A2
--------------------------------------
SELECT agr_hier.agr_name, agr_hier.object_id, agr_hier.parent_id, agr_hier.sort_order,
agr_hier.menu_level, agr_hier.menu_level, agr_hier.report, agr_hiert.text
FROM agr_hier
INNER JOIN agr_hiert
ON agr_hier.agr_name = agr_hiert.agr_name
AND agr_hier.object_id = agr_hiert.object_id
WHERE agr_hier.agr_name = agr_hiert.agr_name
AND agr_hier.report IN ('_APPATION' , 'APPION22' )
-------------------------------------------

https://wiki.sdn.sap.com/wiki/display/ABAP/Useful+SAP+System+Administration+Transactions
http://help.sap.com/saphelp_nw70/helpdata/EN/44/d8120bdaba5705e10000000a1553f6/frameset.htm
http://wiki.sdn.sap.com/wiki/display/Security/Collection+of+SAP+Security+Tables
http://soumen.wordpress.com/performance-tuning-of-sap-another-experiance/5-st02-another-magic-transaction-for-sap-tuners-ii/

where A1.parent_id=A2.object_id
order by A2.TEXT

select agr_name,object_id,text from AGR_HIERt
where mandt='700'
and agr_name like 'Z:%'
order by object_id
-------------------------------------------

SAP Buffer reset

2009-11-09T01:52:00.001-08:00

/$SYNC This resets all buffers of the application server
/$CUA This resets the CUA buffer of the application server
/$TAB This resets the TABLE buffers of the application server
/$NAM This resets the nametab buffer of the application server
/$DYNP - the screen buffer of the application server

/$TAB RSADMIN refreshes buffers for specific tables e.g. RSADMIN
/$TAB refreshes all table buffers + the program buffer
/$SYNC refreshes all table buffers, except the program buffer

SU56 not SM56

SU53 and click authorization values ---> Reset User Buffer.

SU01 -> environment -> mass changes -> reset all user buffers

Executing transaction PFUD or running program RHAUTUPD_NEW

se38 and program: RSUSR405

Setting Your Shell Prompt

2009-08-11T22:03:00.001-07:00

http://hell.org.ua/Docs/oreilly/unix/upt/ch07_01.htm

Basics of Setting the Prompt

The prompt displayed by your shell is contained in a shell variable (6.8) called prompt in the C shell and PS1 in the Bourne shell. As such, it can be set like any other shell variable. [bash and tcsh have plenty of extra features for those two variables. There are examples in later articles. -JP]

So, for example, if I wanted to change my C shell prompt to include my login name, I might put the following command into my .cshrc file:

set prompt="tim % "

(It's helpful to leave the % at the end so that it remains obvious that this is a C shell. The space after the % makes the command you type stand out from the rest of the prompt.)

Or if I wanted to put in the name of the system I was currently logged in on, I might say:

`...` uname -n

set prompt="`uname -n` % "

If I wanted to include the history number for each command, (11.1) I'd say:

set prompt="\! % "

Or if I wanted all three things:

set prompt="tim@`uname -n` \!% "

This will give me a prompt like this:

tim@isla 43%

SAP Database Guide: Oracle (BC-DB-ORA-DBA)

2009-08-06T06:17:00.001-07:00

http://help.sap.com/saphelp_erp2004/helpdata/en/79/5e0540a054e469e10000000a155106/frameset.htm

aix komutları

2009-08-06T03:25:00.000-07:00

smit

bos level;
oslevel
5 version --migration
3 Release
0 Modification -- smith update_all
0 Fix

bos maintenance level
oslevel -r

smit install -- software installation and maintanance
smit install_update
smit install_latest
#geninstall -d /usr..
smit lis_installed
lslpp
-L lists the installed software
-h shows the history of a software product
-p display request information for the fileset
-d dsiplays dependent information for the fileset
-f displays the names of the files added to the system during installation of the fileset
-w lists the fileset that owns a file
-b list software for the specified bundle name
lislpp -l "bos.*"
smit compare_report
smit service_software -software service management(SUMA)
suma
smit maintain_software
gencopy - d /dev/cd0 -t /usr/sys/inst.image all -- copy all software to hard disk for future installation

installs a fix;
#instfix -k IY58143 -d /dev/cd0
Search for a fix;
#instfix -ik IY58143
search for a fix keyword;
instfix -s SCSI -d /dev/cd0
list bos maintance level
instfix -i | grep ML
list missing
#instfix -ciqk 5300-01_AIX_ML | grep :-:
-T displays entire table of contens
-s search for and display table of contents entries containing the string
-k install fileset for a keyword or fix
#instfix -k IY58143 -d /dev/cd0
-f
-i
-a
-d
-c
smit change_documentation_services

accessing the web-based system manager
standalone mode;
#wsm
client-server mode;
#wsm -host
applet mode;
http:///wsm.html
lslpp -h sysmgt.websm.framework
smit web_based_system_manager

HMC Management
#bootlist -m service cd0 hdisk0 hdisk1
#bootinfo -p -architecture
#bootinfo -y -view addresing
#alog -o -t boot - view the boot information
#smit alog

who /var/adm/wtmp
who /var/adm/wtmp | grep "May 17"
/etc/inittab id
runlevel
action
respawn
wait
once
sysinit
off
command
#telinit - reread /etc/inittab file
#shutdown -m a single user mode terminating all logins

System resource controller syntax
list src status
#lssrc -g spooler
start a subsystem
#startsrc -s lpd
refresh a subsystem
# refresh -s lpd
stop a subsystem
#stopsrc -s lpd

Stopping Processes
#ps -ef
not started by srcmstr;
#kill 9345
by SRC;
#stopsrc -s qdaemon

System Shutdown
#shutdown +2 - 2saat sonra kapanacak
-d
-F hızlı kapatır
-h halt o.s.
-i
-k
-m single user mode
-r restart
-t mmddHHMM
-l

Manage the System Environment
#smit system

Manage System Language Environment
#smit mlang

Listing of /deb Directory
#ls -l /dev
cd0
fd0
hd, lv logical volume
hdisk physical volume

List All Support Device
PdDv(Predefined Devices)
#lsdev -P -H
#lsdev -Pc tapes

List All Define Devices
CuDv (Customized Devices)
#lsdev -C -H
#lsattr -EH -l sys0
#lsattr -E -l sys0 -a realmem

Device States
mkdev -l or cfgmgr

SMIT Devices Menu
#smit devices

important aix commands
lsdev -Cc adapter --list all adapters
lsslot -c pci --all slots
lscfg -vl xyz
--------------------
getlvcb -TA hd2
lspv
cfgmgr
lsdev -C -c disk
lspv hdisk1
lspv -l hdisk1
lspv -p hdisk1
lspv -M hdisk1

lsvg
lsvg -o
lsvg -l rootvg
lsvg -p rootvg
lsvg | lsvg -il
lslv newlv
--------------
mpstat cpu bilgileri
mpstat |tail +2 |wc -l

AİX SİSTEMLERDE DİSK BOYUTUNUN ARTTIRILMASI

2009-07-30T05:22:00.000-07:00

Aix sistemlerde df -g komutu ile disk durumlarını görebiliyoruz. Kontrollerimizde disk alanı yetersizliği tespit edersek disklere boş alan eklenmesi ihtiyacı doğmuş demektir (%100, %99, %98 ...vb).

Disk büyütme işlemlerinde öncelikle yapılması gereken ilgili Aix sisteme Ssh ile bağlanılması gerekmektedir. Bağlantı yapıldıktan sonra df -g komutu ile disklerin durumlarını kontrol ederiz.

Görüleceği üzere bir partitionın durumu %98 lere gelmiş. İlerleyen tarihlerde dolduğunda performans ve başka sorunlarla karşılaşılabilir. Bu nedenle bu alana boş alan eklemeliyiz.

Öncelikle boş alanımızın olup olmadığına bakıyoruz. Bu işlemden önce volume groupun karakteriksel özellikleri listelemememiz gerekiyor.. Bu sayade volume groupta boş alan varmı bakacağız. Lsvg komutunu veriyoruz.

Görüleceği üzere rootvg partition unda 92416 Mb, sapvg partitionunda ise 45824 Mb lık boş yerimiz var. 2000Mb eklemeye karar veriyoruz ve disk alanı ekleme komutumuzu veriyoruz.

root@asprod:/> chfs -a size=+2000M /sapmnt/ASP

Bu komut ile 2000Mb alanı /sapmnt/ASP alanına ekliyoruz. Eğer çıkartmak istiyorsak komutta yapacağımız değişiklik size=-2000M dir. Yani artı yı eksi yapıyoruz. Daha sonra disk alanlarını df –g komutu ile incelediğimizde /sapmnt/ASP alanının 2000 Mb arttığını görebiliriz.

src:http://www.ercanpamuk.com/Makaleler/aix_disk_increase.html

AİX SİSTEMLERDE PERFORMANS KONTROLÜ

2009-07-30T05:03:00.001-07:00

Aix sistemlerde belirli zamanlarda performans kontrolü yapılması gerekebilir. Sistemde oalbilecek yavaşlıklarda yada bir darboğaz ile karşılaşıldığında system performansının control edilmesi problemin tespit edilmesinde önemli derecede yardımcı olabilir.

Aix sistemlerde de Linux sistemlerdeki top komutunun bir benzeri olan topas komutu kullanılmatadır. Aix sisteme telnet bağlantısı yapıldıktan sonar komut satırında topas komutu çalıştırılır ve aşağıda göreceğiniz ekran karşınıza gelir.

Bu ekranda sol alt köşede çalışan processlerin PID numaraları, Cpu kullanımları ve procesi kullanan user gibi bilgiler yer almaktadır.

Ortadaki ekranda diskler hakkında bilgiler, en üst soldaki ekranda sistemin durumu, idle gibi bilgiler yer almaktadır.

Eğer sistemde bir yavaşlık varsa ve topas komutu ile system performansı test edildiğinde Cpu kullanım alanına bakılmalıdır. Cpu yu aşırı kullanan bir process varsa bunun ne olduğu üzerine araştırmalar yapılabilir.

src:http://www.ercanpamuk.com/Makaleler/aix_performance_control.html

TİVOLİ STORAGE MANAGER

2009-07-30T04:58:00.002-07:00

Tivoli backup işlemlemlerinin yapıldığı IBM in bir uygulamasıdır. Bir sunucu üzerine kurularak backup library ile entegre çalışmaktadır.

Tivoli backup kartuşları ile arkasına yapıştırılan etiketler vasıtasıyla konuşmaktadır. Kartuş çıkartma, kartuş aldırma ...vb işlemler bu etiketlerdeki numaralar aracılığı ile yapılır.

Basit Tivoli Komutları:

q vol: Library içerisindeki kartuşları ve arşivi gösterir.

q libvol: O an library içerisindeki kullanılan kartuşları gösterir.

q pr: Library deki o an yapılan process leri gösterir.

q ses: O an çalışan sessionları gösterir.

q req: Requestleri listeler

reply : Requesti tetikler.

src:http://www.ercanpamuk.com/Makaleler/tivoli.html

TİVOLİ STORAGE MANAGER

2009-07-30T04:58:00.001-07:00

Split Mirror Backup

2009-07-29T03:04:00.001-07:00

http://help.sap.com/saphelp_nw70/helpdata/en/68/b72d86db13c642bb6e17b83b75f598/frameset.htm

Z_SAP_BC_PRINT

2009-07-27T22:59:00.000-07:00

obj- S_SPO_ACT
field name - SPOACTION
delete -print

S_SPO_ACT
SPOAUTH
*

--------------
S_SPO_DEV
SPODEVICE
%LOC - LP01 - ZLOCAL -
----------------
????
S_SPO_DEV
S_SPO_DEV
*
----------------
S_SPO_PAGE
SPODEVICE
LP01 - ZLOCAL -

SPOPAGES
*
------------
http://help.sap.com/saphelp_nw70/helpdata/EN/c7/58c902e5bf11d18e2b0000e83dd9fc/content.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/d9/4a8eb751ea11d189570000e829fbbd/frameset.htm

SAP_BC_PRN_DISPLAY

Run OS Commands from SAP GUI

2009-07-23T00:34:00.000-07:00

What a interesting piece of information now you can run os commands from SAP GUI.

Just run report RSBDCOS0 in SA38 and enjoy .

You can change working directory and all.Now no need to ask sysadmin to give password also . :)

src:http://sappandit.blogspot.com/2009/04/run-os-commands-from-sap-gui.html

lsvg -volume group listeler
lspv -command output to check your allocated and free physical volumes

http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?topic=/com.ibm.aix.baseadmn/doc/baseadmndita/cmd_display_lastlines.htm

SAP Sistem sapsys kullanıcısı Lock administrator No. 032 process inde “Lock table overflow” hatası.

2009-07-17T22:53:00.001-07:00

SAP Sistem sapsys kullanıcısı Lock administrator No. 032 process inde “Lock table overflow” hatası.

Çözüm;
Lock table enqueue sunucu üzerinde bellekte bulunmaktadır. Enque/table_size büyüklüğü il bu değer KB cinsinden değiştirilebilir.

Raporlu olanlar dikkat

2009-07-17T05:27:00.000-07:00

506 sayılı Kanunun 37 inci maddesi hükmü gereğince istirahatlı bırakılan sigortalılarımıza istirahatın başladığı üçüncü günden itibaren geçici iş göremezlik ödeneği ödenmekte olup,506 sayılı Sosyal Sigortalar Kanununda geçici iş göremezlik ödeneği ödenmeyen 2 gün için işverence ödeme yapılıp yapılmayacağına ilişkin bir hüküm bulunmamaktadır.

SAP lock table overflow

2009-07-17T04:44:00.000-07:00

lock table overflow hatası çok almaya başladıysanız ilk yapacağınız iş
sm12->extrac->statistics
Lock Owner Table, Size alanın dolu mu?
eğer doluysa rz10 ile gidip enque ile ilgili parametreleri kontrol etmeniz gerekir.
ilk olarak enque/table_size alanını değiştirmelisiniz
max değeri 102400 eğer max değerini yazdığınızda hata alıyorsanız;
enque/process_location = REMOTESA parametresini değiştirmelisiniz.
bu değişiklikleri yapmadan önce uygulamacı arkdaşlar ile konuşup uygulamada problem olup olmadığını çek ederseniz uygun olur.

eğer Lock Owner Table, Size dolmuyorsa table lock lı olduğundan hatayı veriyordur. bunda yapılacak bir şey yok.

OTOMATİK KİLİTLEME
Bazı veri tabanı yönetim sistemleri, tablonun değişimine sebebiyet verecek herhangi bir komut (INSERT;UPDATE;DELETE) uygulandığı zaman, o tablo üzerinde otomatik olarak EXCLUSIVE kilitleme oluşturur. Bu kilitleme herhangi bir COMMIT yada ROLLBACK komutu ile ortadan kalkacaktır.
Örnek : LOCK TABLE X IN SHARE MODE;
X tablosu SHARE MODE’da kilitleniyor. Diğer kullanıcılar sadece okuma yapabilir.
Örnek : LOCK TABLE Y IN EXCLUSIVE MODE;
Y tablosu EXCULUSIVE MODE’da kilitleniyor. Diğer kullanıcılar sadece okuma yapabilir. Ve Y tablosu üzerinde kilitleme yapılamaz
----------------------------------
Locking a Table: Example

The following statement locks the employees table in exclusive mode but does not wait if another user already has locked the table:

LOCK TABLE employees
IN EXCLUSIVE MODE
NOWAIT;

The following statement locks the remote employees table that is accessible through the database link remote:

LOCK TABLE employees@remote
IN SHARE MODE;
http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_9015.htm
-------------------------------------

SAP Tuning

2009-07-17T04:26:00.001-07:00

SELECT T_00.VBELN,
T_00.AUART,
T_00.KUNNR,
T_00.SPART,
T_00.VKBUR,
T_00.VKGRP,
T_00.ERDAT,
T_00.VKORG,
T_00.VTWEG,
T_01.POSNR,
T_01.MATNR,
T_01.LGORT,
T_01.WERKS,
T_01.UEPOS,
T_01.VRKME,
T_01.KBMENG,
T_01.KWMENG,
T_01.VSTEL,
T_01.MATKL,
T_04.NAME1,
T_05.MAKTX,
T_06.MTART,
T_06.ZZMAKTX,
T_01.MATKL
FROM VBAK T_00
INNER JOIN
VBAP T_01
ON T_01.MANDT = '700' AND T_01.VBELN
= T_00.VBELN
INNER JOIN
MARD T_02
ON T_02.MANDT = '700'
AND T_01.MATNR = T_02.MATNR
AND T_01.WERKS = T_02.WERKS
AND T_01.LGORT = T_02.LGORT
INNER JOIN
VBUP T_03
ON T_03.MANDT = '700'
AND T_03.VBELN = T_01.VBELN
AND T_03.POSNR = T_01.POSNR
INNER JOIN
KNA1 T_04
ON T_04.MANDT = '700'
AND T_04.KUNNR = T_00.KUNNR
AND T_04.LAND1 = 'TR'
INNER JOIN
MAKT T_05
ON T_05.MANDT = '700'
AND T_05.MATNR = T_01.MATNR
AND T_05.SPRAS = 'T'
INNER JOIN
MARA T_06
ON T_06.MANDT = '700' AND T_06.MATNR =
T_01.MATNR
WHERE T_00.MANDT = '700'
--AND T_00.KUNNR = '0012020076'
AND T_00.AUART = 'ZD01'
AND T_00.VKORG = '1000'
AND T_01.VSTEL = '1000'
AND ( T_03.BESTA = 'A'
OR T_03.BESTA = 'B'
OR T_03.BESTA = 'C')
AND T_00.LIFSK <> 'Z1'
------------------------------------------
select * from v$parameter
where name like '%user_dump%'
-------------------------------------
col name format a10

col value_string format a50

select name, datatype, value_string

from v$sql_bind_capture

where sql_id='drgya7ynf0tn6' and child_number=0

order by position;
-------------------------------------------
select lpad(' ', level ) || operation operations,

object_name, options, cardinality

from (select * from v$sql_plan

where sql_id='drgya7ynf0tn6'

and child_number=0)

connect by prior id=parent_id

start with id=0

order by id, position;
--------------------------------------------
select NAME, VALUe_STRiNG from V$SQL_BIND_CAPTURE
where SQL_ID='drgya7ynf0tn6'

TemSe

2009-07-14T04:23:00.001-07:00

TemSe is basically a data store that is used for storing temporary sequential data/objects.
Such data/objects are not required to be held permanently in the system. A few TemSe objects/data among others are stated below:

Spool Data
Job Logs
Objects from HR, Fin, etc. applications

Storage Location for TemSe:

Each TemSe object has a header entry in table TST01 and the actual object, which can be stored on the file system (OS Level-performance advantage) or table TST03 (DB Level- backup by default for being a part of DB).

Let’s look how the different objects are preferred to be stored generally.

Spool Data: By default stored in TST03, along with entries in TSP01 (for Spool Requests) and TSP02 (for Output Requests). However, we do have an option of selecting the storage of these objects that can be defined through the profile parameter: rspo/store_location (db value: stored in table TST03, G value: stored in global dictionary in OS)
Job Logs: Stored in File system on OS Level.
HR Objects, etc.: Stored in TST03

Managing TemSe Objects:

TemSe is not an archiving system.

And so we need to always make sure that the number of objects and memory allocation do not increase in the system. We need to delete objects that are no longer required. Deletion can be done as follows:

i. Deleting spool requests either by SPAD (if less in number) or else running report RSPO0041
ii. Deleting job logs through report RSBTCDEL. (Deleting job logs directly might lead to inconsistencies. Instead, it is better to delete the batch jobs responsible for the same)
iii. If we are very sure about the TemSe objects that need to be deleted, we can run the report RSTS0022. However, this can lead to inconsistencies while deleting spool objects as this report clears entries only in table TST01 and not the corresponding entries in TSP01/TSP02. Hence, after using this report, best practice is to perform consistency checks on Spooler and TemSe.

In case of spool requests, print list archiving is possible though.

Also, TemSe objects have a retention period. We need to check if any objects have unlimited retention period. This Expiry Time can be checked as below:

SP12 t-code, then from the menu bar selects Gotoà TemSe Contents.

This screen will get us to all the matching objects. Thereafter, double clicking any row i.e. particular object name gives us all the details about the object (e.g. Object Name, Creator, Creation Date, Last Changed on, Expiry Date, Where the object is stored, its record type, size, client, etc.)

TemSe cannot manage objects that require more than 2 GB storage space: This is irrespective of the storage location used i.e. DB or OS. Also, the total number of objects in TemSe varies from 30k to 40k generally.

We can check the memory allocation for TemSe through SP12 T-Code.
From the menu bar, we need to select TemSe Data StorageàMemory allocation.

This gives us an overview of Storage space available in Database and file system for each client. It has further sections, detailing the TemSe object name and the amount of space used across DB/ file.
http://sapbasisnotes.blogspot.com/2009/07/temse-overview.html

SAP Kullanıcının yazıcı ayarlarının değiştirilmesi

2009-07-13T23:35:00.000-07:00

-su01 ile ilgili kullanıcı seçilir.
-değiştir butonuna basılır.
-sabit değerler alanına geçilir.
-mevcut yazıcı alanına istenen yazıcı yazılır.
-hemen yazdırmak isteniliyorsa hemen yazdır seçeneği seçilir.

AIX monitoring tools

2009-07-10T06:35:00.000-07:00

-Online monitoring

xmperf graphical monitor
http://publib16.boulder.ibm.com/doc_link/en_US/a_doc_lib/perftool/prfusrgd/ch02bod
y.htm.

-Operating system tools

topas
vmstat
iostat
nmon
http://www.ibm.com/developerworks/aix/library/au-nmon_analyser/index.html.

-zOS and DB2 reports
The tools used for creating the reports are:
* RMF Postprocessor
* RMF Spreadsheet reporter

http://web.utanet.at/mario/exam/5129cd4.htm

SAP Transactions for technical monitoring

2009-07-10T06:33:00.001-07:00

AL08: List of all users logged on

SM12: Lock entry list

SM66: Global work process overview
The type of a process
Dialog process: DIA
Update: UPD
enqueue: ENQ
batch: BTC
spool: SPO
V2 update: UP2

STAD: Transaction analysis
Programs with long response times

ST02: Overview of SAP buffers
In general, the hit ratio should be at least 98%. swaps 0 olmalı

ST04N: Database overview
önemli olan data buffer quality %99 larda olmalı,
db cache quality %80 üstünde olmalı

ST05: SQL trace analysis
Process;
1. Start SQL Trace using ST05
2. -n.Generate load
3. -n.Stop SQL Trace
4. .-n.Analyze the trace

OS07/ST06: System monitor
The CPU utilization (CPU Utilization user) should not constantly range above 60
to 70% per CPU.
it is recommended that not more than 20% of the physical main memory should be
swapped per hour.
Thus, in a system with 4 GB of memory, swap rates of up to 200
KB/second are acceptable. But in general you can say the smaller the swap rate, the better

The utilization of the slowest hard disk (Disk with highest response time value in the
Response time group) should range below 50%. If that is not the case, the hard disk may be
overloaded.

LAN Errors in/s and LAN Errors out/s
should be 0

LAN Collisions greater than 0

SM04: User list

SM21: System log

ST22: ABAP run time error

LC10: liveCache monitoring

AANA: Transaction for the statistical evaluation of database tables
Due to the usage of Native-SQL, transaction TAANA is to be preferred to evaluations with
transaction SE16.

ST12 - Trace analysis

SE30 - Runtime analysis
– Measurement in dialog status
– Measurement of external session
– Planning a measurement
– Selection of measurement restrictions
– Analyzing measurement results

SM37 - Job overview

SAP reports

2009-07-10T06:11:00.000-07:00

#df -g File systems disk usage
exportfs -v Exported file systems
lsps -a Paging area definition
ifconfig -a TCP/IP configuration
lspv hdisk0 -hdisk0 characteristics
lsvg rootvg -rootvg characteristics
mount -Mounted file systems

STAD

Transaction for the current monitoring process Transaction for the retroactive analysis
AL08 - List of all users logged on SM21 - Display system log
OS07 - Operating System Monitor ST04 - Database monitor
SM04 - User List ST05 - Performance analysis
SM12 - Lock entry list ST22 - ABAP Runtime Error
SM66 - Global work process overview STAD - Display statistical records
OS07 (via OS Collector)

-Use of Transaction STAD
The analysis shows that the database time represents a large portion of the total run time.

- Use of the operating system analysis of the database server via Transaction ST06 in order
to check the hardware utilization of the database server (CPU, memory)
The analysis returns a high degree of CPU utilization of the database server.

-Database analysis
The status of the database is checked using ST04.

SAP user ve role table

2009-07-09T23:40:00.001-07:00

su01
------
USR21
ADR6 -> SMTP_ADDR
ADRC
USR01
AGR_USERS->role

SE43
-------
SMEN_BUFFC
SMENSAPT ->OBJECTID
SMENSAPNEW ->OBJECTID

AGR_USERS USR21
-------- -------
MANDT MANDT
AGR_NAME START_MENU
UNAME BNAME
------------------------------------------------

PRINTER TABLE

TSP01 TSP02
------- -------
RQOWNER -user PJRECEIVER, PJOWNER -user
RQ1NAME -printer PKDEST -printer
RQPOSNAME - winismi PJPOSNAME -winismi

TSP02FX USR01
-------- --------
OWNER -user BNAME
TERMINAL -terminal SPLD

select rqowner, rq1name, rqposname from tsp01
where rqowner='$user'

select distinct rqowner from tsp01

select * from tsp02fx

select bname, SPLD from usr01 where spld='LOCE'

select distinct spld from usr01

select * from tsp02fx

tsp01, tsp02, tsp02fx, usr21

--------------------------------------------------

ROLE - TCODE TABLE

AGR_USERS, AGR_TCODES, AGR_1251

SELECT
TA.AGR_NAME AS LJS, TB.AGR_NAME AS SEVK,
TA.OBJECT AS LJS_OBJ, TB.OBJECT AS SVK_OBJ,
TB.MANDT, TA.MANDT,
TA.FIELD AS LJS_FIELD,
TB.FIELD AS SVK_FIELD,
TA.LOW AS LJS_LOW,
TB.LOW AS SVK_LOW,
TA.NODE AS LJS_NODE,
TB.NODE AS SVK_NODE
FROM (select * from AGR_1251--AGR_USERS
----AGR_TCODES
where AGR_NAME='$role') TA
inner join
(select * from AGR_1251--AGR_USERS
where AGR_NAME='$role') TB
on TA.OBJECT=TB.OBJECT
AND TA.OBJECT='S_TCODE'
AND TA.MANDT='$client' AND TB.MANDT='$client'
AND TA.FIELD=TB.FIELD
AND TA.LOW=TB.LOW
-----------------------------------------------------

SAP se43 Area Menu oluşturma

2009-07-09T23:09:00.000-07:00

-se43 ile giriyoruz.

-istersek yeni bir menu seçebilir. istersek mevcut menulerden seçebilirz.
-istediğimiz alanın altına eklemek için o alana select(f9) diyoruz.

-add entry... diyerek ekliyoruz. Sonrada sakla dedikten sonra request ekranı geliyor.

-Request olusturduktan sonra se09 - transport ekranına gelip release ediyoruz

SAP su01-su10 Kullanıcı Tanımlama

2009-07-09T23:06:00.000-07:00

-su01 ile giriyoruz.

-oluşturulacak user id yazıyoruz. ve create diyoruz.

-en azından soyadı kısmını doldurmamız yeterli.

-parolasını veriyoruz.

-rol tabına geçip. rollerini verip

-save dememiz yeterli.

-eğer kullanıcılar da toplu parametre değişikliği yapmak istiyorsak su10 işlem kodunu seçmemiz yeterli. ör: parametre değişikliği gibi.

SAP Stms ile request taşıma

2009-07-09T23:02:00.000-07:00

-stms işlem kodu nu yazıyoruz.

-kamyon işaretini tıklıyoruz.

-QA sistemi seciyoruz.

-release id secip import que diyoruz (2.sırada)

-yes diyoruz.

-login ekranı

-ust birimini yazıyoruz.

-kendi kullanıcımızla login oluyoruz.

-release id status yeşil oluyor.

-seçip – import request diyoruz.

-target client i yazıyoruz.

-ok diyoruz.

- canlı için de aynı işlemleri yapıyoruz fakat target client i farklı olacaktır.

SAP Oracel Parametreleri Uyarıları

2009-07-09T22:35:00.000-07:00

-QUERY_REWRITE_ENABLED parametresi true olursa ana tablonun materialized view i varsa sorguda mv e bakıyor. false olursa sorgu yaparken mv in belirtilmesi gerekir. eğer güncel veriler istiyorsanız materialized view yerine ana tabloyu sorgulamanız daha doğru olur. mv in avantajı sorgularda performans sağlayacaktır.

-REPLICATION_DEPENDENCY_TRACKING parametresi replike çalışan sunucularınız varsa true yapmanız gerekecektir. aksi takdirde false olması daha doğru olur.

-STATISTICS_LEVEL parametresin 10 g ile birlikte default değeri typical geliyor. sadece tablo gözlemleme amaçlı düşünmeyelim. AWR, ASSM, ADDM gibi onemli raporlama alanlarının takibi ile de sorumlu. metalink 252597.1

-STAR_TRANSFORMATION_ENABLED parametresi CSO sorguya dönüştürülmesine karar veriyor. SQL kalıpların alt sorgulara bölünerek Bitmap indexlerden yararlanılmasını sağlar. perfomans için true olmalıdır.

-SHARED_POOL_SIZE parametresi default değeri “0” da bırakılmışsa bu demektedir ki sga target ile belirlediğimiz alanı içerisinden shared pool alanına MMAN arka planda karar veriyor. eğer default değerini değiştirirsek default değerinin altına inmez.

-PARALLEL_EXECUTION_MESSAGE_SIZE parametresi default değeri 2kb dir. Slave process ile coordinator arasındaki buffer miktarını belirler. Eğer mesajlar büyükse parçalanır. Bu azda olsa performans kaybına neden olur. 8kb yapılabilir.

-OPTIMIZER_FEATURES_ENABLE parametresi ile db nin hangi release sahip olduğu belirtilir.

-LOG_BUFFER parametresi Redo log alanın büyüklüğünü belirler. Büyük olması i/o maliyetini düşürür.

-CRITICAL_TABLESPACE tablespace alanlarınıda kritik seviyede bulunan varsa uyarı verir.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm