tag:blogger.com,1999:blog-86665170710375615982024-03-13T06:36:07.303+07:00Ardhian - Another BlogAnonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.comBlogger60125tag:blogger.com,1999:blog-8666517071037561598.post-46014430145970020072016-03-22T09:45:00.001+07:002016-03-24T10:04:50.073+07:00Berburu spare part kendaraan di Pusat Onderdil Kedungdoro #Part2 (Broker mode)<div style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin-bottom: 10px;">
Berawal dari postingan lama gw (<a href="http://ardhian.wordpress.com/2010/11/08/berburu-spare-part-kendaraan-di-pusat-onderdil-kedungdoro/#comment-10828" style="color: #0c5390; text-decoration: none;" target="_blank">Berburu spare part kendaraan di Pusat Onderdil Kedungdoro</a>), banyak yang memberikan komentar, meminta bantuan untuk dicarikan spare part, dan beberapa pertanyaan lain. Bahkan sampai saat ini pun masih banyak yang bertanya dan minta tolong dicarikan spare part tertentu.</div>
<div style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin-bottom: 10px;">
Ok, deh. Saya hanya bermaksud membantu teman-teman terutama yang luar kota Surabaya untuk bisa mencari spare part kendaraan di pusat onderdil Kedungdoro (termasuk yang terlengkap di Surabaya). Kebetulan sekali, tempat kerja saya dekat sekali dengan Kedungdoro, jadi bisa saya sempatkan untuk sekedar mencarikan spare part untuk teman-teman.</div>
<div style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin-bottom: 10px;">
Prosedur pemesananan :</div>
<ol style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin: 0px 0px 14px 36px; padding: 0px;">
<li style="list-style-type: decimal;">Telp/SMS/WA ke nomor saya (085330356073). Jenis spare part, kendaraan (merek & tipe), tahun. Catatan : saya prefer WA karena akan lebih mudah (bisa kirim gambarnya juga)</li>
<li style="list-style-type: decimal;">Jika sudah menemukan spare part, saya akan balas SMS/WA yang isinya harga spare part (jika memungkinkan beserta gambar spare part). Jika deal, saya akan kirimkan berapa total yang harus ditransfer ke no rekening BCA saya : 298 – 054 – 5094 atas nama Lies Ardhian Inaroka, ST.</li>
<li style="list-style-type: decimal;">Barang akan dikirim plus saya akan SMS/WA no resi-nya.</li>
</ol>
<div style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin-bottom: 10px;">
Jika ada yang berminat untuk dicarikan spare part kendaran, silakan PM saya, Ardhian (Telp/SMS/WA : 085330356073)</div>
<div style="background-color: white; color: #333333; font-family: Helvetica, Arial, Tahoma, sans-serif; font-size: 12px; line-height: 19.2px; margin-bottom: 10px;">
Sekali lagi, jangan sungkan-sungkan untuk bertanya atau minta tolong yah.</div>
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-28091521425879205022016-02-25T15:13:00.000+07:002016-02-25T15:13:04.286+07:00Suka duka tentang Asisten Rumah TanggaSejak memiliki anaka, ada yang berubah dalam rumah. Dulu waktu baru hidup berdua dengan istri, saya belum berpikir macam-macam. Jalanin aja, ikuti alur kehidupan seperti air mengalir.<br />
<br />
Kehadiran anak memberikan warna yang berbeda. Karena saya dan istri sama-sama bekerja (saya sebagai karyawan swasta dan istri sebagai PNS), mau tidak mau membutuhkan asisten rumah tangga. Tujuan mencari asisten rumah tangga adalah menjaga anak saat kami berdua sedang bekerja atau tidak berada di rumah. Mencari asisten rumah tangga yang amanah dan cocok memang gampang-gampang susah. Sampai merepotkan orang tua dan mertua. Karena kami mencari asisten rumah tangga dari desa, bukan mencari dari yayasan penyalur PRT.<br />
<br />
Asisten rumah tangga pertama kami dari desa yang sama dengan saya. Baru satu bulan, dia mesti pulang karena merasa berat meninggalkan anaknya di desa (walaupun ada mbah-nya). Waktu itu tahun 2009 dan dia masih saya gaji 350 ribu plus uang transport 50 ribu (catatan : asisten rumah tangga memang saya kasih waktu libur dan bisa mudik sebulan sekali). <br />
<br />
Asisten rumah tangga yang kedua masih sama, satu desa dengan saya. Yang ini bertahan cukup lama. Saya dan istri selama ini selalu berbaik sangka dan tidak berpikir aneh-aneh tentang yang satu ini. Asisten yang satu ini memiliki 2 anak dan sudah bercerai dengan suaminya. Satu anaknya berdomisili di Balikpapan dan satunya di desa yang sama dengan asal saya. Sampai suatu saat (sekitar awal tahun 2011), asisten ini menghilang dan hanya meninggalkan pesan lewat sms. Ternyata dia menikah lagi (secara siri) dan sudah hamil. Gaji terakhirnya adalah 600 ribu plus transport 50 ribu.<br />
<br />
Karena asisten yang kedua ini lari tanpa kejelasan, saya dan istri agak kelimpungan. Akhirnya saya minta bantuan ke sepupu untuk menemani. Hampir selama setahun sepupu ikut saya sampai akhirnya anaknya minta agar pulang. Sebenarnya hampir tiap bulan, saya tetap kasih libur untuk menengok anaknya. Setiap bulan juga saya tetap kasih 700 ribu plus uang transport 50 ribu.<br />
<br />
Asisten rumah tangga berikutnya dari daerah Maospati, tempat adik saya bertugas sebagai bidan. Asisten yang ini tidak terlalu lama dan tidak banyak membantu. Akhirnya saya pulangkan karena pernah pergi tanpa pamit selama 3 hari. Gaji terakhirnya adalah 700 ribu plus uang transport 50 ribu.<br />
<br />
Asisten berikutnya adalah mencari orang lokal. Orang daerah Keputih. Sebenarnya orangnya rajin tetapi karena dia juga membantu di tempat lain juga, akhirnya tidak fokus ke tugasnya. Apalagi pada masa ini anak saya yang kedua lahir. Gaji terakhirnya 750 ribu.<br />
<br />
Dengan berbagai cara akhirnya saya mendapatkan asisten yang merupakan kenalan lama. Sebelumnya dia pernah bekerja untuk bersih-bersih di tempat kos istri saya waktu masih kuliah. Kebetulan saya dan istri sudah kenal lama dengannya. Kami juga kenal dengan suaminya. Suaminya bekerja sebagai tukang bangunan. Suaminya sering kami minta bantuan untuk renovasi rumah. Pada masa ini, kami juga kedatangan anak yang ke-3. Asisten ini memiliki 1 anak yang masuk masa remaja. Dengan asisten yang ini bertahan sampai saat ini walaupun dipenuhi dengan berbagai problematikanya. Gaji yang saya berikan dari awal adalah 800 ribu dan sudah beberapa kali saya naikkan. Terakhir gaji yang saya berikan adalah 1,3 jt (lebih dari rata-rata gaji asisten rumah tangga di sekitaran rumah).Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-28048879415250121322015-11-11T09:48:00.000+07:002015-11-11T09:48:21.478+07:00Video Instalasi SuSE Linux Enterprise Server 12Berikut step by step video instalasi SuSE Linux Enterprise Linux 12 (the latest version).<br />
<br />
Semoga bermanfaat.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/dRXG_fYa1wc/0.jpg" src="https://www.youtube.com/embed/dRXG_fYa1wc?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-63899305719659656852014-01-29T12:41:00.002+07:002014-01-29T12:41:48.451+07:00Long access on table DYNPLOAD, DYNPSOURCE, and REPOLOADProblem SAP gw sebelumnya adalah lama akses ke beberapa tabel, yaitu ke DYNPLOAD, DYNPSOURCE, dan REPOLOAD. Ketiga tabel itu termasuk tabel-tabel volatile SAP. Artinya tidak akan masuk ke dalam profile update statistic.<br />
<br />
Tadi siang, gw coba lakukan runstats (update statistic) secara manual langsung ke database db2-nya.<br />
<br />
syntax :<br />
<br />
db2 runstats on table sap[sid].dynpload with distribution and detailed indexes all<br />db2 runstats on table sap[sid].dynpsource with distribution and detailed indexes all<br />db2 runstats on table sap[sid].repoload with distribution and detailed indexes all<br />
<br />
Sepertinya hal ini ada efeknya sedikit. Terbukti sebelum gw lakukan runstats, akses ke tabel DYNPLOAD memerlukan waktu 8 menit 26 detik. Setelah dilakukan runstats, akses hanya memerlukan waktu sekitar 2 menit.<br />
<br />
Semoga bener tuh...he..he..Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-77926956070052364192014-01-28T14:49:00.001+07:002014-01-28T14:49:41.251+07:00lsdev: 0514-521 Cannot find information in the predefined device configuration database for the customized device iocp0<span style="font-weight: bold;">Got an error when typing lsdev -C and lscfg command.</span><br /><br /><span style="font-family: courier new; font-weight: bold;"># lsdev -C | grep Defined</span><br /><span style="font-size: 85%;">lsdev: 0514-521 Cannot find information in the predefined device<br /> configuration database for the cu</span>stomized device iocp0.<br /><br /><span style="font-family: courier new; font-weight: bold;"># lscfg -vl hdisk</span><span style="font-weight: bold;">0</span><br /><span style="font-size: 85%;"><span style="font-family: courier new;">0519-004 libodm: The specified search criteria is incorrectly formed.</span><br /><span style="font-family: courier new;"> Make sure the criteria contains only valid descriptor names and</span><br /><span style="font-family: courier new;"> the search values are correct.</span><br /><br /><span style="font-family: courier new;"> hdisk0 P2/Z1-A8 16 Bit LVD SCSI Disk Drive (18200 MB)</span><br /><br /><span style="font-family: courier new;"> Manufacturer................IBM</span><br /><span style="font-family: courier new;"> Machine Type and Model......DDYS-T18350M</span><br /><span style="font-family: courier new;"> FRU Number..................00P1520</span><br /><span style="font-family: courier new;"> ROS Level and ID............53423041</span><br /><span style="font-family: courier new;"> Serial Number...............9EGQ4829</span><br /><span style="font-family: courier new;"> EC Level....................F79924</span><br /><span style="font-family: courier new;"> Part Number.................07N3842</span><br /><span style="font-family: courier new;"> Device Specific.(Z0)........000003029F00013A</span><br /><span style="font-family: courier new;"> Device Specific.(Z1)........07N4924</span><br /><span style="font-family: courier new;"> Device Specific.(Z2)........0933</span><br /><span style="font-family: courier new;"> Device Specific.(Z3)........01242</span><br /><span style="font-family: courier new;"> Device Specific.(Z4)........0001</span><br /><span style="font-family: courier new;"> Device Specific.(Z5)........22</span><br /><span style="font-family: courier new;"> Device Specific.(Z6)........F79924</span><br /></span><span style="font-weight: bold;">Solution:</span><br /><br /><span style="font-weight: bold;">1. Backup ODM.</span><br /> tar -cvf /tmp/ODM.tar /etc/objrepos/<br /><br /><br /><span style="font-weight: bold;">2. Delete the iocp0 device from CuDv </span><br /> odmdelete -q "name=iocp0" -o CuDv<br /><br />0518-307 odmdelete: 1 objects deleted.<br /><br /><span style="font-weight: bold;">3. Now it is clean</span>Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-17694593309792650852014-01-20T13:26:00.000+07:002014-01-20T13:26:19.485+07:00Buruh, UMP, UMK, Demo, PHK, dan OutsoucingProblematika dunia buruh di Indonesia adalah masalah upa minimum provinsi alias UMP atau untuk wilayah kabupaten & kota adalah UMK. Setiap menjelang akhir tahun, selalu ada demonstrasi alias unjuk rasa dari para buruh alias kelas pekerja yang menuntut kenaikan UMP/UMK.<br />
<br />
Problemnya adalah tidak semua perusahaan selalu untung dan siap menaikkan upah buruh-nya sesuai UMP/UMK yang ditetapkan. Ini menjadi tarik ulur antara buruh, pengusaha, dan pemerintah selaku mediator. Jika sesuai permintaan buruh maka bisa jadi akan terjadi PHK alias pengurangan tenaga kerja karena perusahaan tidak mampu membayar upah. Jika pengusaha tidak menaikkan upah, demonstrasi yang terus menerus juga akan memperburuk keadaan perusahaan, selain karena operasional perusahaan terganggu dan produksi berkurang, hal ini juga menjadi preseden buruk bagi dunia usaha Indonesia.<br />
<br />
Beberapa hari lalu ada beberapa saudara yang bekerja di sebuah perusahaan PMA di Kalimantan Timur yang terkena PHK dan terpaksa pulang kampung. Pulang kampung ini juga disertai dengan membawa keluarga (anak+istri) yang selama ini menjadi tanggungan.<br />
<br />
Gw sempat diminta bantuan untuk mencarikan pekerjaan di tempat gw bekerja saat ini. Gw juga bilang kalau tidak bisa menjanjikan dengan pasti. Insya Allah akan gw usahain. Semoga ada jalan yang terbaik. Atau mungkin waktunya membuka lapangan pekerjaan sendiri dengan wirausaha.<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-46849664294215109392014-01-18T13:31:00.001+07:002014-01-18T13:31:05.632+07:00Niat Memulai UsahaDari dulu saya pengen memulai bisnis. Entah itu berhubungan dengan IT seperti pekerjaan saya saat ini ataupun jauh dan tidak ada hubungan sama sekali dengan IT.<br />
<br />
Beberapa minggu yang lalu terbersit ide untuk bisnis jualan gas elpiji. Berangkat dari kenaikan harga gas elpiji kemasan 12 Kg. Kalo dihitung-hitung memang margin keuntungannya kecil, apalagi untuk kemasan 3 Kg. Margin keuntungan sekitar Rp 2.000,00 - Rp 3.000,00.<br />
<br />
Dari beberapa kali search persyaratan untuk menjadi sub agen (kalo jadi agen perlu semacam badan usaha dan stok yang diperlukan lumayan banyak) cukup beragam. Ada yang menyebutkan cukup dengan mempunyai tabung gas 3 Kg dan atau 12 Kg kosong minimal 100, ijin usaha dari RT/RW, ijin gangguan, sudah bisa memulai usaha. Tentu saja harus memiliki tempat atau gudang untuk penyimpanan. Tempat penyimpanan diharapkan mempunyai ventilasi yang cukup dan memiliki perangkat APAR (minimal 2 biji).<br />
<br />
Kayaknya bisa untuk mulai jualan kecil-kecilan. He..he..he..<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-14432411206082511412014-01-02T11:09:00.000+07:002014-01-02T11:09:30.134+07:002014 : New Year...New Hope...Hard WorkTahun baru identik dengan segala sesuatu yang baru. Mulai dari semangat baru, pengalaman baru, harapan baru, dan impian baru.<br />
Ya....sebaiknya memang seperti itu. Isi hidup ini dengan semangat dan gairah baru...<br />
<br />
Selamat tahun baru 2014 !!Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-46563241146957925342013-08-16T13:10:00.000+07:002013-08-16T13:10:01.816+07:00Configure NTP clients under AIX and RHEL to syncronize with NTP serverThis tutorial explains how to configure NTP on client with a NTP
server. In all below examples we have two NTP servers ntp01 and ntp02.
Here one as a primary and other one is secondary if primary fails
secondary will take it up.<span id="more-853"></span><br />
Step 1 : Verify that you have a server suitable for synchronization by using below command<br />
<div class="codesnip-container">
# ntpdate -d ip.address.of.server ( Both for AIX and Linux )</div>
Example<br />
<div class="codesnip-container">
[root@webmanual01 ~]# ntpdate -d ntp01.webmanual.com<br /><span>
17 Jan 06:44:16 ntpdate[31056]: ntpdate <a class="smarterwiki-linkify" href="mailto:4.2.2p1@1.1570-o">4.2.2p1@1.1570-o</a> Wed Sep 3 14:28:30 UTC 2008 (1)</span><br />
Looking for host ntp01.webmanual.com and service ntp<br />
host found :ntp01.webmanual.com<br />
transmit(10.88.36.2)<br />
receive(10.88.36.2)<br />
transmit(10.88.36.2)<br />
receive(10.88.36.2)<br />
transmit(10.88.36.2)<br />
receive(10.88.36.2)<br />
transmit(10.88.36.2)<br />
receive(10.88.36.2)<br />
transmit(10.88.36.2)<br />
server 10.88.36.2, port 123<br />
stratum 3, precision -17, leap 00, trust 000<br />
refid [10.88.36.2], delay 0.02718, dispersion 0.00005<br />
transmitted 4, in filter 4<br />
reference time: d2bfeb7d.3713f077 Tue, Jan 17 2012 6:43:41.215<br />
originate timestamp: d2bfeba1.0dc1b541 Tue, Jan 17 2012 6:44:17.053<br />
transmit timestamp: d2bfeba1.055a2941 Tue, Jan 17 2012 6:44:17.020<br />
filter delay: 0.02785 0.02718 0.02722 0.02733<br />
0.00000 0.00000 0.00000 0.00000<br />
filter offset: 0.032242 0.031947 0.031990 0.031962<br />
0.000000 0.000000 0.000000 0.000000<br />
delay 0.02718, dispersion 0.00005<br />
offset 0.031947
17 Jan 06:44:17 ntpdate[31056]: adjust time server 10.88.36.2 offset 0.031947 sec</div>
The offset must be less than 1000 seconds for xntpd to synch. If the
offset is greater than 1000 seconds, change the time manually on the
client and run the ntpdate -d again.<br />
Step 2: Specify your xntp servers in /etc/ntp.conf . Comment out the
“broadcastclient” line (if applicable )and add server ip.address/name of
NTP server<br />
# vi /etc/ntp.conf<br />
Example for Linux <br />
<div class="codesnip-container">
[root@web-manual01 ~]# cat /etc/ntp.conf<br />
server ntp01.webmanual.com<br />
server ntp02.webmanual.com<br />
driftfile /var/lib/ntp/drift<br />
authenticate yes</div>
Example for AIX<br />
<div class="codesnip-container">
#broadcastclient<br />
driftfile /etc/ntp.drift<br />
tracefile /etc/ntp.trace<br />
server ntp01.webmanual.com<br />
server ntp02.webmanual.com</div>
Leave the driftfile and tracefile at their defaults.<br />
Step 3 : Start the xntpd/nfsd daemon:<br />
<div class="codesnip-container">
# startsrc -s xntpd (AIX )<br />
# service ntpd start (Linux)</div>
Step 4: Making ntpd to start on reboot <br />
AIX : Uncomment xntpd from /etc/rc.tcpip so it will start on a reboot.<br />
<div class="codesnip-container">
# vi /etc/rc.tcpip<br />
Uncomment the following line<br />
start /usr/sbin/xntpd “$src_running”</div>
Linux : Run the command ” chkconfig ntpd on” so it will start on a reboot.<br />
Step 5 :Verify that the client is synched.<br />
AIX Steps:<br />
<div class="codesnip-container">
# lssrc -ls xntpd</div>
Example <br />
<div class="codesnip-container">
lssrc -ls xntpd<br />
Program name: /usr/sbin/xntpd<br />
Version: 3<br />
Leap indicator: 00 (No leap second today.)<br />
Sys peer: ntp01.webmanual.com<br />
Sys stratum: 5<br />
Sys precision: -17<br />
Debug/Tracing: DISABLED<br />
Root distance: 0.029816<br />
Root dispersion: 0.043655<br />
Reference ID: 10.160.14.46<br />
Reference time: d2bff453.c0f33000 Tue, Jan 17 2012 7:21:23.753<br />
Broadcast delay: 0.003906 (sec)<br />
Auth delay: 0.000122 (sec)<br />
System flags: pll monitor filegen<br />
System uptime: 707799 (sec)<br />
Clock stability: 0.000107 (sec)<br />
Clock frequency: 0.000000 (sec)<br />
Peer: ntp01.webmanual.com<br />
flags: (configured)(sys peer)<br />
stratum: 4, version: 3<br />
our mode: client, his mode: server<br />
Peer: ntp01.webmanual.com<br />
flags: (configured)(sys peer)<br />
stratum: 4, version: 3<br />
our mode: client, his mode: server<br />
Subsystem Group PID Status<br />
xntpd tcpip 13162 active</div>
NOTE: Sys peer should display the IP address or name of your xntp server. This process may take up to 15 minutes. <br />
Linux Steps<br />
The ntpq utility program (both for Linux and AIX )is used to monitor
NTP daemon ntpd operations and determine performance and -p Print a list
of the peers known to the server as well as a summary of their state<br />
<div class="codesnip-container">
ntpq -p</div>
Example (Linux)<br />
<div class="codesnip-container">
[root@webmanual01 sysconfig]# ntpq -p<br />
remote refid st t when poll reach delay offset jitter<br />
==============================================================================<br />
*ntp01.webmanual.com 169.254.0.1 3 u 70 128 377 2.043 -0.053 1.619<br />
+ntp02.webmanual.com 169.254.0.1 3 u 52 128 377 1.934 -0.294 1.908</div>
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-45867953951535765972013-05-22T14:27:00.000+07:002013-05-22T14:27:30.930+07:00Downlod : Komik Deni Manusia Ikan<i><b>Deni Manusia Ikan</b></i> (judul asli: <i><b>Fishboy: Denizen of the Deep</b></i>) adalah <a href="http://id.wikipedia.org/wiki/Komik" title="Komik">komik</a> hitam putih yang diterbitkan pertama kali di buku <i><a class="new" href="http://id.wikipedia.org/w/index.php?title=Buster&action=edit&redlink=1" title="Buster (halaman belum tersedia)">Buster</a></i> antara <a href="http://id.wikipedia.org/wiki/1968" title="1968">1968</a> dan <a href="http://id.wikipedia.org/wiki/1975" title="1975">1975</a>, ditulis oleh <a class="new" href="http://id.wikipedia.org/w/index.php?title=Scott_Goodall&action=edit&redlink=1" title="Scott Goodall (halaman belum tersedia)">Scott Goodall</a> dan digambar oleh <a class="new" href="http://id.wikipedia.org/w/index.php?title=John_Stokes&action=edit&redlink=1" title="John Stokes (halaman belum tersedia)">John Stokes</a>
dan lain-lain. Tokoh utamanya adalah seorang anak laki-laki yang
terdampar di sebuah pulau dan belajar untuk bernapas di bawah air dan
berbicara dengan makhluk-makhluk air. Ia juga memiliki insang dan tangan
kaki berselaput sehingga dapat berenang dengan cepat. Tujuan hidupnya
adalah mencari orangtuanya dan membantu orang yang kesusahan.<br />
<br />
Link download<br />
<br />
<a href="http://adf.ly/PN9y9" target="_blank">vol 1</a><br />
<a href="http://adf.ly/PNA1N" target="_blank">vol 2</a><br />
<a href="http://adf.ly/PNA3v" target="_blank">vol 3</a><br />
<a href="http://adf.ly/PNA6n" target="_blank">vol 4</a><br />
<a href="http://adf.ly/PNAA2" target="_blank">vol 5</a><br />
<a href="http://adf.ly/PNAEA" target="_blank">vol 6</a><br />
<a href="http://adf.ly/PNAI4" target="_blank">vol 7</a><br />
<a href="http://adf.ly/PNALD" target="_blank">vol 8</a><br />
<a href="http://adf.ly/PNAN8" target="_blank">vol 9</a><br />
<a href="http://adf.ly/PNAPB" target="_blank">vol 10</a><br />
<a href="http://adf.ly/PNAT0" target="_blank">vol 11</a><br />
<a href="http://adf.ly/PNAWx" target="_blank">vol 12</a><br />
<a href="http://adf.ly/PNAZL" target="_blank">vol 13</a><br />
<a href="http://adf.ly/PNAcB" target="_blank">vol 14</a><br />
<a href="http://adf.ly/PNAeS" target="_blank">vol 15</a><br />
<a href="http://adf.ly/PNAgw" target="_blank">vol 16</a><br />
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-63916067886703176752013-04-17T10:39:00.000+07:002013-04-17T10:39:11.313+07:00Download link : SAPGUI 7.30 for WindowsSilakan bagi yang membutuhkan SAPGUI 7.30 for Windows.<br />
<br />
<a href="http://adf.ly/N6rKR" target="_blank">SAPGUI 7.30 for Windows</a>Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-48294960174337388022013-04-03T09:54:00.001+07:002013-04-03T09:54:41.178+07:00Komik Shoot Hot Challenge Part 2)Sesuai permintaan, lanjutan dari Komik Shoot yang pertama (33 bagian), yaitu Shoot Hot Challenge (mulai no 7 - 12).<br /><br />
Link download :<br />
<br />
<a href="http://adf.ly/M7r6P" target="_blank">No 7</a><br />
<a href="http://adf.ly/M7rBJ" target="_blank">No 8</a><br />
<a href="http://adf.ly/M7rET" target="_blank">No 9</a><br />
<a href="http://adf.ly/M7rv7" target="_blank">No 10</a><br />
<a href="http://adf.ly/M7rz3" target="_blank">No 11</a><br />
<a href="http://adf.ly/M7s3C" target="_blank">No 12</a> Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com6tag:blogger.com,1999:blog-8666517071037561598.post-46901047516387823862013-03-15T13:02:00.001+07:002013-03-15T13:02:26.065+07:00Download : Driver Pack Solution 13 R314 Final<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-Gfe0Q93ioJQ/UTyY647QO-I/AAAAAAAAAd0/wKh3za_8_DY/s1600/DP.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="http://4.bp.blogspot.com/-Gfe0Q93ioJQ/UTyY647QO-I/AAAAAAAAAd0/wKh3za_8_DY/s400/DP.jpg" width="291" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Assalamualaikum wr.wb,<br />
<div style="text-align: justify;">
Kali ini berbagi link download Driver Pack Solution 13 R314. Versi R314
sendiri merupakan versi penyempurnaan dari versi sebelumnya.yaitu R306.
Driver Pack solution adalah software untuk men-scan dan menginstal
driver yang belum terinstal secara otomatis tanpa harus repot-repot cari
driver jika di website resmi laptop belum menyediakan Driver khususnya
bagi OS terbaru Windows 8. Driver Pack Solution dapat digunakan dengan
mudah tanpa harus instal karena bersifat portable dan bisa dijalankan
dari removable disk (<i>flash disk, micro SD, dll</i>). </div>
<br />
<a href="http://4.bp.blogspot.com/-IB04DKgZqTI/UTyXn80BQ3I/AAAAAAAAAds/3HCcvcz9kp0/s1600/DriverPack-Solution-13-R314-Menu.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="266" src="http://4.bp.blogspot.com/-IB04DKgZqTI/UTyXn80BQ3I/AAAAAAAAAds/3HCcvcz9kp0/s400/DriverPack-Solution-13-R314-Menu.png" style="cursor: move;" width="400" /></a><br />
<br />
<div style="text-align: justify;">
Khususnya bagi anda yang PC Notebook atau Netbook nya belum support
driver Windows 8, software ini merupakan alternatif paling mudah dan
efektif karena secara otomatis akan mendeteksi driver yang harus
dipasang atau diinstal pada PC anda setelah menginstal Windows 8 baik
Windows 8, Windows 8 Pro, Windows 8 Enterprise, maupun Windows 8 RTM.
Tapi bukan berarti Driverpack Solution 13 R314 ini tidak bisa digunakan
untuk menginstal di OS Windows 7. Sangat mungkin menginstal Driver
Laptop untuk Windows 7 meskipun biasanya tidak digunakan karena di
website resmi pasti sudah menyediakan driver untuk Windows 7 sendiri. </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Seperti yang sudah diulas di atas, Driverpack Solution 13 R314 sangat
mudah digunakan dan tidak memerlukan keahlian khusus dalam
menjalankannya, sehingga bagi anda yang pemula dalam hal instal driver
dapat menjalankannya, inshallah, dengan sempurna. Itu semua karena hal
yang perlu anda lakukan adalah menjalankan DriverPackSolution.exe
kemudiakan akan diarahkan untuk men-scan driver dan dilanjutkan
instalasi. </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Berikut deskripsi mengenai Driver Pack Solution 13 R314</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
DriverPack Solution v 13.0.314 Final (ML)</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Fully updated shell DRP 12.12 automatically select and install the
correct driver for your computer. This version has many new features and
optimized for the new operating system Windows 8. Compared with the
previous version of the DRP 12.3 in this version has corrected the shell
and completely new driver packs. Installing the drivers is in the
envelope just a few clicks and the process can be fully automated.
Thanks freshest driver-pakam, the program installs the drivers on
virtually any computer of any age. Install and update the drivers of
this program is not connected to the Internet directly from the HDD /
flash / DVD</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Included in the collection of driver packs:</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
• DP_Biometric_13023.7z</div>
<div style="text-align: justify;">
• DP_Bluetooth_13024.7z</div>
<div style="text-align: justify;">
• DP_CardReader_13025.7z</div>
<div style="text-align: justify;">
• DP_Chipset_13025.7z</div>
<div style="text-align: justify;">
• DP_LAN_13023.7z</div>
<div style="text-align: justify;">
• DP_MassStorage_13024.7z</div>
<div style="text-align: justify;">
• DP_Misc_13024.7z</div>
<div style="text-align: justify;">
• DP_Modem_13023.7z</div>
<div style="text-align: justify;">
• DP_Monitor_13024.7z</div>
<div style="text-align: justify;">
• DP_Notebook_13024.7z</div>
<div style="text-align: justify;">
• DP_Printer_13003.7z</div>
<div style="text-align: justify;">
• DP_Sound_ADI_13023.7z</div>
<div style="text-align: justify;">
• DP_Sound_CMedia_13024.7z</div>
<div style="text-align: justify;">
• DP_Sound_Conexant_13023.7z</div>
<div style="text-align: justify;">
• DP_Sound_Creative_13024.7z</div>
<div style="text-align: justify;">
• DP_Sound_IDT_13023.7z</div>
<div style="text-align: justify;">
• DP_Sound_Others_13023.7z</div>
<div style="text-align: justify;">
• DP_Sound_VIA_13014.7z</div>
<div style="text-align: justify;">
• DP_Sounds_HDMI_13024.7z</div>
<div style="text-align: justify;">
• DP_Sounds_Realtek_13022.7z</div>
<div style="text-align: justify;">
• DP_Telephone_13025.7z</div>
<div style="text-align: justify;">
• DP_TV_Aver_13024.7z</div>
<div style="text-align: justify;">
• DP_TV_Beholder_13014.7z</div>
<div style="text-align: justify;">
• DP_TV_DVB_13021.7z</div>
<div style="text-align: justify;">
• DP_TV_Others_13012.7z</div>
<div style="text-align: justify;">
• DP_Video_AMD_Desktop_13024.7z</div>
<div style="text-align: justify;">
• DP_Video_AMD_Notebook_13023.7z</div>
<div style="text-align: justify;">
• DP_Video_AMD_Server_13014.7z</div>
<div style="text-align: justify;">
• DP_Video_Hybrid_13012.7z</div>
<div style="text-align: justify;">
• DP_Video_Intel_13024.7z</div>
<div style="text-align: justify;">
• DP_Video_MacBook_13015.7z</div>
<div style="text-align: justify;">
• DP_Video_nVIDIA_Desktop_13025.7z</div>
<div style="text-align: justify;">
• DP_Video_nVIDIA_Notebook_13024.7z</div>
<div style="text-align: justify;">
• DP_Video_nVIDIA_Server_13023.7z</div>
<div style="text-align: justify;">
• DP_Video_Others_13022.7z</div>
<div style="text-align: justify;">
• DP_WebCam_13025.7z</div>
<div style="text-align: justify;">
• DP_WLAN_13025.7z</div>
<div style="text-align: justify;">
• DP_xUSB_13025.7z</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Additional Information: </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
• Under the DVD size of 38 driver packs in this assembly were only 35
(not included in the video drivers for the servers and MacBook - if you
choose to continue downloading and add themselves to the assembly) </div>
<div style="text-align: justify;">
• Kit is distributed in the form of ISO-image - it can be burned to DVD
or unzip archiver or Total Commander as a normal file and run it from
your hard drive or flash driveImage Checksum: </div>
<div style="text-align: justify;">
• MD5: 22c4a6494f798f0bcf77b81b7cc4b284 </div>
<div style="text-align: justify;">
• Image Size: 4480mb (disk capacity 4483mb DVD + R / DVD-R 4489mb)System requirements: </div>
<div style="text-align: justify;">
• For all versions of Windows from XP to 8Platform / OS: Windows ® 2000 | XP | Vista | 7 & 8 (x32 | x64)</div>
<div style="text-align: justify;">
Developer: DriverPack Solution</div>
<div style="text-align: justify;">
Release released: 2013</div>
<div style="text-align: justify;">
Activation: not required</div>
<div style="text-align: justify;">
Language: ML</div>
<div style="text-align: justify;">
File Format: iso</div>
<div style="text-align: justify;">
File Size: 4.37 GB</div>
<div style="text-align: justify;">
</div>
<div style="text-align: center;">
</div>
<div style="text-align: center;">
Secara ringkas dapat disimpulkan bahwa DriverPack Solution 13 R314:</div>
<div style="text-align: center;">
1. Koleksi driver yang lengkap</div>
<div style="text-align: center;">
2. Support OS windows xp/vista/7/8</div>
<div style="text-align: center;">
3. Support sistem 32 bit dan 64 bit</div>
<div style="text-align: center;">
4. Tidak perlu diinstal cukup dijalankan saja</div>
<br />
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Bagi yang berkenan untuk mendapatkan DriverPack Solution 13 R314 ini silakan download di link di bawah.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Rapidgator</div>
<div style="text-align: justify;">
<a href="http://adf.ly/KrwK0" target="_blank">Part1</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/KrwYf" target="_blank">Part2</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/KrwcC" target="_blank">Part3</a></div>
<div style="text-align: justify;">
<a href="http://rapidgator.net/file/85554b1bedec3fa6f3bcfc4376fc740b/DriverPack.Solution.v13.R314-01.03.2013.part04.rar.html" target="_blank">Part4</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/KrwiR" target="_blank">Part5</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/Krwl1" target="_blank">Part6</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/Krwnk" target="_blank">Part7</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/Krwpo" target="_blank">Part8</a></div>
<div style="text-align: justify;">
<a href="http://adf.ly/Krwsi" target="_blank">Part9</a></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Selamat mendownload </div>
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com1tag:blogger.com,1999:blog-8666517071037561598.post-36771547823444331492013-03-02T10:20:00.000+07:002013-03-02T10:20:19.925+07:00The Avengers : Earth's Mightiest Heroes - downloadFilm animasi The Avengers : Earth's Mightiest Heroes bisa didownload sini :<br />
<br />
<a href="http://adf.ly/K5A7h" target="_blank">Episode 1 : Breakout (Part 1)</a><br />
<a href="http://adf.ly/K5AZD" target="_blank">Episode 2 : Breakout (Part 2)</a><br />
<a href="http://adf.ly/K5AmH" target="_blank">Episode 8 : Some Assembly Required</a> <br />
<a href="http://adf.ly/K5AuL" target="_blank">Episode 9 : Living Legend</a> <br />
<a href="http://adf.ly/K5B1q" target="_blank">Episode 10 : Everything is Wonderful</a><br />
<a href="http://adf.ly/K5BAQ" target="_blank">Episode 11 : Panther's Quest</a><br />
<a href="http://adf.ly/K5BFK" target="_blank">Episode 12 : Gamma World (Part 1)</a><br />
<a href="http://adf.ly/K5BPo" target="_blank">Episode 13: Gamma World (Part 2)</a> <br />
<a href="http://adf.ly/K5Bxm" target="_blank">Episode 14 : Masters of Evil</a> <br />
<a href="http://adf.ly/K5C5k" target="_blank">Episode 15 : 459</a> <br />
<a href="http://adf.ly/K5CB7" target="_blank">Episode 16 : Widow's Sting</a> <br />
<a href="http://adf.ly/K5CG9" target="_blank">Episode 17 : The Man who Stole Tomorrow</a> <br />
<a href="http://adf.ly/K5CNa" target="_blank">Episode 18 : Come the Conqueror</a> <br />
<a href="http://adf.ly/K5CTE" target="_blank">Episode 19 : The Kang Dinasty</a> <br />
<a href="http://adf.ly/K5CXp" target="_blank">Episode 20 : The Casket of Ancient Winters</a> <br />
<br />
Semoga bermanfaat dan selamat downloadAnonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-36837536525566455182013-02-21T15:51:00.001+07:002013-02-21T15:51:39.205+07:00Download Kitab Suci Holy Quran 8.0Holy Quran 8.0 adalah program kitab suci Al Qur’an dalam berbagai fitur
yang sangat berguna untuk berinteraksi dan mengkaji isi kitab suci Al
Qur’an.<br /><br /><a href="http://4.bp.blogspot.com/-GiWmhWaLfnY/T4KoMHMXe9I/AAAAAAAAAXc/xJGpoHVZuzM/s1600/holy%2Bquran.png"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5729326602011507666" src="http://4.bp.blogspot.com/-GiWmhWaLfnY/T4KoMHMXe9I/AAAAAAAAAXc/xJGpoHVZuzM/s320/holy%2Bquran.png" style="cursor: hand; cursor: pointer; float: left; height: 243px; margin: 0 10px 10px 0; width: 320px;" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Sekilas tentang Holy Quran 8.0<br />
<ul><br />
<li>Program
berisi penayangan seluruh naskah Alquran dengan sistim penulisan Usmani
sesuai dengan Mushaf terbitan Madinah dan Mushaf yang biasa beredar di
Indonesia, lengkap dengan tanda baca dan indeks menurut surah dan juz.</li>
<br />
<li>Program menyediakan fasilitas bacaan murattal oleh Syekh Huzaifi dan Syekh Muhammad Ayyub dengan fasilitas penggantian suara.</li>
<br />
<li>Program
menyediakan fasilitas pencarian canggih dalam naskah Alquran dengan
mengunakan teknik urai bahasa terhadap kata atau kalimat dengan beberapa
kategori, sehingga memberikan kemampuan pencarian yang tinggi kepada
pengguna biasa maupun ahli. Di samping itu, juga menyediakan fasilitas
pencarian tematis, di mana Program telah menyediakan 14 tema pokok yang
terbagi menjadi sub tema, kemudian sub sub tema melalui 6 tingkatan,
hingga jumlah semua tema carian menjadi lebih dari 2000 tema. Semua
jenis carian itu dapat dilakukan oleh pengguna dalam seluruh naskah
Alquran atau dalam skop yang telah dia tentukan. Pencarian juga dapat
dilakukan dalam tafsir dan terjemah.</li>
<br />
<li>Program menyediakan
penayangan gambar dan suara terhadap makhraj huruf dan sifat-sifatnya
serta cara pengucapannya yang benar untuk membantu pengguna dalam
belajar membaca Alquran.</li>
<br />
<li>Program menerangkan hukum tajwid
secara praktis, seperti; tingkatan qalqalah, jenis-jenis mad… dan
seterusnya, serta dilengkapi dengan macam-macam contoh dari naskah
Alquran dan suara pengucapan yang betul bagi setiap hukum.</li>
<br />
<li>Terakhir,
Program memungkinkan pengguna untuk memilih salah satu bahasa pengantar
dari bahasa-bahasa berikut: Arab , Indonesia , Malaysia, Inggris,
Prancis, Jerman, Turki, Urdu, Spanyol</li>
</ul>
<a href="http://adf.ly/JXZvs" target="_blank">CD 1</a> <br />
<a href="http://adf.ly/JXa5V" target="_blank">CD 2</a> <br />
<br />
Selamat download !!<br />
<br />Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com1tag:blogger.com,1999:blog-8666517071037561598.post-57330048824500016822013-02-21T11:27:00.002+07:002013-02-21T11:27:08.056+07:00Free Avast Antivirus License Key till 2038<a class="alignleft zemanta-img" href="http://en.wikipedia.org/wiki/File:Avast-2010-Logo.svg" target="_blank"><img alt="Avast!" class="zemanta-img-inserted zemanta-img-configured" height="106" src="http://upload.wikimedia.org/wikipedia/en/thumb/5/5b/Avast-2010-Logo.svg/287px-Avast-2010-Logo.svg.png" title="Avast!" width="287" /></a><br />
AVAST Software leads the security software industry – protecting
131,723,971 active and 166,235,486 registered users around the globe –
by distributing FREE antivirus software that makes no compromises in
terms of protection. Dependable and fast, with a small resource
footprint, it often outperforms competitors’ paid-for antivirus suites.<br />
<strong>Avast Antivirus License Key:</strong> W6754380R9978A0910-4TZ59467<br />
<div>
This license key also works with the previous versions of Avast Antivirus and will activate them till 2038.<strong>Note:</strong> This
is a free license key and will only work with the free version of Avast
Anitvirus. This is NOT valid for the paid version! Download Avast
Antivirus Free Version <a href="http://filehippo.com/download_avast_antivirus/">here</a>.</div>
<div>
You can also download the VPS (virus database) for those who are not always connected to the internet by clicking <a href="http://www.avast.com/de-de/download-update" target="_blank">here</a> and installing on your various pc system.</div>
<div>
Remember to share this with your friends and family.<br />
</div>
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-91032327392287840632013-02-20T08:54:00.001+07:002013-02-20T08:54:40.208+07:00Download : Another SAP e-booksHere are another SAP ebooks worthed to download and must have. Title "Implementing SAP ERP Sales and Distribution" from McGraw-Hill.<br />
<br />
<a href="http://adf.ly/FpqRx">http://adf.ly/FpqRx</a><br />
<br />
Happy downloading guysAnonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-91342677548749852422013-02-16T09:20:00.000+07:002013-02-16T09:20:08.550+07:00Download : DB2 LUW Administration for SAPAda ebook menarik dari SAP DB2.<br />
<br />
<a href="http://adf.ly/JBxbJ" target="_blank">DB2 LUW Administration for SAP</a>.<br />
<br />
Selamat download.Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-56857646042579457682013-01-19T08:59:00.001+07:002013-01-19T08:59:32.808+07:00Implementing Row Compression in EDW on DB2 9.5After upgrading the EDW to DB2 9.5 on LUW, Row Compression was the first
feature we wanted to implement amongst other features as it clearly
gave the biggest bang for the buck.<br /><br /><strong>Benefits:-</strong><br /><br />As
Row Compression reduces average record length and stores more number of
rows per page, it directly reduces storage space needs. This also
benefits in reduced I/O and increases throughput. Backup and Recovery
can also be faster due to reduced database size. Only downside however
is the increased CPU utilization (roughly 10%) needed to carry out
compression and de-compression.<br /><br /><strong>Selecting Candidate Tables:- </strong><br /><br />Largest
tables are always the best candidates for compression. Each of the 15
tables we picked up ranged between 300 GB to 1.1 TB in size and between 2
billion to 5 billion in number of rows. We did not anticipate as much
higher compression ratio on these tables as theoretically possible,
because most of the columns in these tables were integers and dates.
Though, the compression estimates carried out did match closely to what
we finally achieved.<br /><br /><strong>Pre-Compression Considerations:- </strong><br /><br />Converting
the tablespace to LARGE, particularly for tables with smaller average
record length, is very important before proceeding to compress. LARGE
tablespaces enables storage of more that 254 rows per page which is a
limitation on REGULAR tablespace. As compression reduces the record
length, there is a greater need to be able to store more rows per page.<br /><br />Compression ratio, dictionary size, and space savings can be estimating in advance using <span style="font-family: courier new; font-size: 85%;">INSPECT</span> command along with <span style="font-family: courier new; font-size: 85%;">db2inspf</span>
format utility. Knowing space saving estimates also helps in selecting
right candidates for compression. Steps to derive estimates can be
illustrated by below example. Note however that in a multi-partitioned
environment separate output is produced for each logical partition.<br /><br /><span style="font-family: courier new;"><strong><span style="color: #000066;"><span style="font-family: courier new; font-size: 85%;">inspect rowcompestimate table name $table schema $schema results keep $file;<br />db2inspf $file $file.txt</span></span></strong></span><br /><strong>Two Approaches on Compressing Existing Tables:- </strong><br /><br /><u><strong>Option# 1: Offline Reorg</strong></u><br />In
this approach, existing tablespace is firstly converted to LARGE, and
then tables are enabled for compression using ALTER TABLE…COMPRESS YES
clause followed by an offline REORG to build a compression dictionary.
If there are multiple tables in the tablespace, we start with the
smallest tables so that any unused extents hiding below HWM are freed
and can be used for Reorg of larger tables.<br /><br /><em><strong>Pros: </strong></em>- REORG scans all rows and builds the most optimal compression dictionary<br />-
System temporary tablespace can be used for shadow copy (space
equivalent to that of compressed table) to offload data during REORG.<br />-
Partitions (or Ranges) in a Partitioned Tables are Reorg-ed
sequentially, needing shadow copy space only equivalent to largest of
the partitions.<br />- Suitable for small DMS tablespaces having one or more tables<br /><br /><em><strong>Cons:</strong></em>- Table needs to be offline for the duration of REORG.<br /><br /><em><strong>Example:</strong></em><br /><strong><span style="color: #000066;"><span style="font-size: 85%;"><span style="font-family: courier new;">alter tablespace $tbspace convert to LARGE;<br />alter table $schema.$table compress yes;<br /><br />reorg table $schema.$table use $systempspace resetdictionary;<br /><br />-- Alternative Approach:<br />-- inspect rowcompestimate table $table schema $schema;<br />-- reorg table $schema.$table use $systempspace keepdictionary;<br /><br />runstats on table $schema.$table with distribution and indexes all;<br /><br />list tablespaces show detail;<br /><br />alter tablespace $tbspace reduce (all n K);</span> </span></span></strong><br /><br /><u><strong>Option# 2: Copy and Rename </strong></u><br />This
approach, suitable for large tablespaces, consists of copying existing
tables to a new tablespace, compressing the new table and swapping names
of new and existing tables. An offline REORG is performed on new table
using sampled data from existing table to build compression dictionary.<br /><br /><em><strong>Pros:</strong></em>- Table can be online except for the momentary switch to rename it.<br />- No shadow copy space needed<br />- 10% sampling is good enough for most of the large tables.<br />- Load From Cursor with Replace can be used to load entire data from base table to backup table.<br /><br /><strong><em>Cons: </em></strong><br />- Extra space is needed to create the backup table.<br />- Compression rate may not be as good as that from Offline Reorg method.<br /><br /><strong><em>Example:</em></strong><br /><strong><span style="color: #000066;"><span style="font-family: courier new; font-size: 85%;">create LARGE tablespace $tbspace_NEW … autoresize yes;<br />-- Allocate only about 60% of used space of $tbspace as total space to $tbspace_NEW<br /><br />create table $schema.$table_NEW (…) in $tbspace_NEW;<br />-- Copy indexes, constraints, and grants from $schema.$table<br /><br />alter table $schema.$table_NEW compress yes;<br /><br />declare c1 cursor for select * from $schema.$table tablesample bernoulli(10) with ur;<br />load from c1 of cursor replace into $schema.$table_NEW NONRECOVERABLE;<br /><br />reorg table $schema.$table_NEW resetdictionary;<br /><br />declare c2 cursor for select * from $schema.$table with ur;<br />load from c2 of cursor replace into $schema.$table_NEW NONRECOVERABLE;<br /><br />runstats on table $schema.$table_NEW with distriburion and indexes all;<br /><br />rename table $schema.$table to $table_OLD;<br />rename table $schema.$table_NEW to $table;</span></span></strong><br /><strong>Compressing Large EDW tables:-</strong><br />Considering
the large size of EDW tables and need to minimize planned outage, the
Copy and Rename approach described above was found to be most suitable.
It allowed us to compress the tables during daytime with minimal direct
impact on the workload. While the procedure used to compress tables was
conceptually similar to that described earlier under Copy and Rename
approach, following exceptions had to be made to increase efficiency of
the operations:<br /><br />1. We preferred NOT LOGGING the copy transactions to reduce elapsed time.<br />2.
INSERT… FROM SELECT method preceded by ALTER TABLE … ACTIVATE NOT
LOGGED INITIALLY was found to be faster than LOAD … FROM CURSOR with
NONRECOVERABLE clause in our DPF environment with 70 logical DATA nodes
spread across 9 p4 servers and 2 p6 servers. So, the INSERT…FROM SELECT
method was used to copy the existing tables.<br />3. Creation of Indexes, including primary key indexes, was deferred until after the new table was loaded.<br /><br />Thus the procedure followed to compress these 15 largest tables can be illustrated by below example:<br /><br /><strong><span style="color: #000066;"><span style="font-family: courier new; font-size: 85%;">create LARGE tablespace $tbspace_NEW … autoresize yes increasesize 10 percent;<br />-- Allocated 60% of used space of $tbspace as total space to $tbspace_NEW<br /><br />create table $schema.$table_NEW like $schema.$table not logged initially in $tbspace_NEW;<br />-- No indexes, or PK created at this time<br /><br />alter table $schema.$table_NEW compress yes;<br /><br />update command options using c off;<br /><br />alter table $schema.$table_NEW activate not logged initially with empty table;<br />insert into $schema.$table_NEW<br />select * from $schema.$table tablesample bernoulli (10) with ur;<br />commit;<br /><br />update command options using c on;<br /><br />reorg table $schema.$table_NEW resetdictionary;<br /><br />update command options using c off;<br /><br />alter table $schema.$table_NEW activate not logged initially with empty table;<br />insert into $schema.$table_NEW select * from $schema.$table with ur;<br />commit;<br /><br />update command options using c on;<br /><br />create index … on $schema.$table_NEW (…);<br /><br />alter table $schema.$table_NEW add primary key (…);<br /><br />runstats on table $schema.$table_NEW with distriburion and indexes all;<br /><br />grants … on table $schema.$table_NEW to …;<br /><br />rename table $schema.$table to $table_OLD;<br />rename table $schema.$table_NEW to $table;<br /><br />rename tablespace $tbspace to $tbspace_OLD<br />rename tablespace $tbspace_NEW to $tbspace<br />-- tablespace rename is optional. It changes the minimum recover time of the tablespace.</span></span></strong><br /><br /><strong>Post-Compression tasks:- </strong><br /><br />1.
To collect compression statistics, we preferred using below functions
over the SYSIBMADM views as these views, under the cover, execute the
same functions on all tables in catalog before applying any WHERE
clauses specified for the table name.<br /><br /><span style="color: #000066; font-family: courier new; font-size: 85%;"><strong>select * from table (sysproc.ADMIN_GET_TAB_INFO_V95('${schema}','${table}')) as T1;<br />select * from table (sysproc.ADMIN_GET_TAB_COMPRESS_INFO('${schema}','${table}','REPORT')) as T2;</strong></span><br />2. Based on the amount of used space versus allocated space, reduce the container sizes.<br />3. Take a tablespace or database level backup.<br />4. Monitor CPU utilization.<br />5. Measure query performance improvements.<br /><br /><strong>Conclusion:-</strong><br />We
achieved row (or data) compression ratio of 35% to 55% and space
savings (including data and indexes) in the range of 25% to 47% for 15
of the largest tables compressed. The savings matched very closely to
the estimates. As stated earlier, compression ratio depends on the
pattern of data, and as our tables mostly had integers, the compression
savings may not be as impressive as it would have been with
text-dominated data.<br /><br />We did however see that for cross-reference
tables with just few columns, LARGE tablespace stored up to 800 rows per
16K page with average row compression ratio (original average row size /
compressed average row size) of 2.<br /><br />Overall, all of the 15 tables that occupied 4.6 TB are now compressed to 3.1 TB resulting in 32% space savings.<br /><br />We now look forward to DB2 9.7 for index compression.
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-50752680364387844792013-01-15T08:08:00.000+07:002013-01-15T08:08:32.249+07:00Set your hardware and system clocks with the date and hwclock commandsToday we’re looking at the date and hwclock commands to set your system and hardware clocks.<br /><br />Have you ever put a server into production only to realize that you had not set the hardware clock to UTC or any other time? When you’ve already put the machine into production it’s pretty difficult to go to your manager and tell him that you need to shut the machine down to set the hardware clock. Using the date and hwclock commands will allow you to set both clocks with shutting down you machine.<br /><br />Computer systems, administrators and users all rely on the correct date and time to function properly or make their jobs go smoother. The system uses cron to execute programs at a certain time. As an administrator you need the correct time when checking logs and looking for problems. If the system clock is off see how long it takes your users to start calling about incorrect dates and times on their documents. In short things are not going to go smoothly if the date and time is wrong on the system.<br /><br />The most likely scenario is that your system clock is off because it is relying on your hardware clock for the correct time. Here is how we correct this. First you need to set the correct time for the system with the date command. Type the date command to see the date and time format of the string:<br /><br /> [root@virtual-host ~]# date<br /> Sun Nov 16 16:51:53 EST 2008<br /> [root@virtual-host ~]#<br /><br /> We want to use this exact type of string to set our system clock:<br /><br /> date --set=Sat Nov 15 18:49:00 EST 2008<br /><br /> Ok now we are going to set our hardware clock to this date:<br /><br /> hwclock --systohc --utc<br /><br /> That’s it. Now your hardware clock is set and your system clock can now keep the correct time by referring to it. You can also set your system clock from your hardware clock with the following command:<br /><br /> hwclock --hctosys<br /><br />Both of these can be particularly important if you are trying to set up the ntp daemon to an internet time source and your system clock is off by more than a 1000 seconds. The ntp daemon will not work under these conditions so you must correct them.<br /><br />Hope this helps you keep your systems on time!Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-5302875672261603292012-12-19T09:30:00.003+07:002012-12-19T09:30:34.532+07:00How to change system date in LinuxThis morning i need to change system date in linux to test one of my
application. Too bad i’m not familiar with command line command linux.
So after googling for sometime, i manage to find out how to change
system date in Linux using command line.
<br />
To change system date in linux, type:-<br />
<span id="more-88"></span><br />
<strong>$date MMDDhhmmYYYY.ss</strong><br />
For example: i want to change my system date to Jun 29 2006, 3.30pm, i will type:-<br />
<strong>$date 062915302006</strong><br />
It’s simple <img alt=":)" class="wp-smiley" src="http://www.techiecorner.com/wp-includes/images/smilies/icon_smile.gif" /> <br />
<strong>Note:</strong><br />
MM – month<br />
DD – day<br />
YYYY – year<br />
hh – hour is based on 24 hour<br />
mm – minutes<br />
ss – secondsAnonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-15523652911945913602012-12-12T10:17:00.001+07:002012-12-12T10:17:38.000+07:00Download Cerita Silat Dewa ArakBerikut ada beberapa ebook cerita silat Dewa Arak yang bisa didownload.<br />
<br />
Setan Mabok (<a href="http://adf.ly/FrzO7">http://adf.ly/FrzO7</a>)<br />
<br />
Tiga Macan Lembah Neraka (<a href="http://adf.ly/FrzTQ">http://adf.ly/FrzTQ</a>)<br /><br />
Tenaga Inti Bumi (<a href="http://www.blogger.com/goog_385773054">http://adf.ly/FrzVu</a>)<br /><br />
Teror Macan Putih (<a href="http://adf.ly/FrzXy">http://adf.ly/FrzXy</a>)<br /><br />
Rahasia Syair Leluhur (<a href="http://adf.ly/FrzZo">http://adf.ly/FrzZo</a>)<br /><br />
Perkawinan berdarah (<a href="http://adf.ly/Frzfl">http://adf.ly/Frzfl</a>)<br /><br />
Runtuhnya Sebuah Kerajaan (<a href="http://adf.ly/Frzhc">http://adf.ly/Frzhc</a>)<br /><br />
Penghuni Lembah Malaikat (<a href="http://adf.ly/FrzkM">http://adf.ly/FrzkM</a>)<br /><br />
Prahara Hutan Bandan (<a href="http://adf.ly/Frzlm">http://adf.ly/Frzlm</a>)<br /><br />
Pertarungan Raja - Raja Arak (<a href="http://adf.ly/Frzxo">http://adf.ly/Frzxo</a>)<br /><br />
Pendekar Tangan Baja (<a href="http://adf.ly/Fs00B">http://adf.ly/Fs00B</a>)<br /><br />
Raja Tengkorak (<a href="http://adf.ly/Fs021">http://adf.ly/Fs021</a>)<br /><br />
Pedang Bintang (<a href="http://adf.ly/Fs03F">http://adf.ly/Fs03F</a>)<br /><br />
Perjalanan Menantang Maut (<a href="http://adf.ly/Fs04E">http://adf.ly/Fs04E</a>)<br /><br />
Malaikat Tanpa Wajah (<a href="http://adf.ly/Fs05u">http://adf.ly/Fs05u</a>)<br /><br />
Misteri Raja Racun (<a href="http://adf.ly/Fs07M">http://adf.ly/Fs07M</a>)<br /><br />
Macan - macan betina (<a href="http://adf.ly/Fs08q">http://adf.ly/Fs08q</a>)<br /><br />
Kembalinya Raja Tengkorak (<a href="http://adf.ly/Fs09r">http://adf.ly/Fs09r</a>)<br /><br />
Kelelawar Beracun (<a href="http://adf.ly/Fs0Bb">http://adf.ly/Fs0Bb</a>)<br /><br />
Mahluk Dari Dunia Asing (<a href="http://adf.ly/Fs0Co">http://adf.ly/Fs0Co</a>)<br /><br />
Neraka untuk Sang Pendekar (<a href="http://adf.ly/Fs0EM">http://adf.ly/Fs0EM</a>)<br /><br />
Keris Peminum Darah (<a href="http://adf.ly/Fs0Fd">http://adf.ly/Fs0Fd</a>)<br /><br />
Manusia Kelelawar (<a href="http://adf.ly/Fs0H0">http://adf.ly/Fs0H0</a>)<br /><br />
Memburu Putri Datuk (<a href="http://adf.ly/Fs0I3">http://adf.ly/Fs0I3</a>)<br /><br />
Empat Dedengkot Pulau Karang (<a href="http://adf.ly/Fs0JU">http://adf.ly/Fs0JU</a>)<br /><br />
Ilmu Halimun (<a href="http://adf.ly/Fs0KY">http://adf.ly/Fs0KY</a>)<br /><br />
Banjir Darah di Bojong Gading (<a href="http://adf.ly/Fs0LF">http://adf.ly/Fs0LF</a>)<br /><br />
Geger Pulau Es (<a href="http://adf.ly/Fs0Me">http://adf.ly/Fs0Me</a>)<br /><br />
Dewi Penyebar Maut (<a href="http://adf.ly/Fs0Nt">http://adf.ly/Fs0Nt</a>)<br /><br />
Algojo - Algojo Bukit Larangan (<a href="http://adf.ly/Fs0P9">http://adf.ly/Fs0P9</a>)<br /><br />
Jamur Sisik Naga (<a href="http://adf.ly/Fs0Pw">http://adf.ly/Fs0Pw</a>)<br />
<br />
Semoga bermanfaat.Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-81123735620513351292012-12-11T11:08:00.000+07:002012-12-11T11:08:04.150+07:00Download : McGraw-Hill Implementing SAP ERP Sales and DistributionMumpung ada ebook bagus untuk dishare.<br />
Silakan didownload.<br />
<br />
Ebook : McGraw-Hill Implementing SAP ERP Sales and Distribution<br />
<br />
Download disini (<a href="http://adf.ly/FpqRx">http://adf.ly/FpqRx</a>)Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-80867535312566946272012-12-04T08:34:00.002+07:002012-12-04T08:34:40.746+07:00STMS : queue list hangDalam beberapa kasus Transport Management
System SAP atau STMS, terkadang dijumpai kasus dimana status queue tidak
bisa menampilkan status. Pada prosesnya hanya dijumpai gambar truk dan
status message “copying ….”<br />
Dicoba untuk re-configure TMS juga tidak memberikan hasil.<br />
Jika menemui kasus seperti ini, silakan ikuti langkah-langkah berikut :<br />
- Tutup STMS<br />
- Silakan periksa proses-proses tp pada level OS. Jika terdapat proses tp, silakan di-kill.<br />
- Dicoba kembali STMS-nya.<br />
Apabila cara diatas tidak berhasil, silakan ikuti cara berikut nya :<br />
- Tutup STMS<br />
- Masuk ke dalam folder usr/sap/trans/tmp. Lihat apakah ada file
Sxxxx.SID.LOC dan Axxxx.SID.LOC. Jika ada, silakan di-rename, misal
menjadi Sxxxx.SID.LOC.old dan Axxxx.SID.LOC.old.<br />
- Pastikan tidak ada proses to yang aktif di level OS.<br />
- Silakan dicoba lagi STMS nya.<br />
Semoga membantu<br />
Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0tag:blogger.com,1999:blog-8666517071037561598.post-64013750828083492502012-12-03T09:49:00.001+07:002012-12-03T09:49:56.525+07:00Download ebook SAP R/3HandbookSAP saat ini merupakan ERP yang paling populer. Banyak yang ingin belajar dan berkecimpung di dunia SAP. Salah satunya bisa dipelajari lewat ebook ini.<br />
<br />
Ebook terbitan McGraw-Hill : SAP R/3 Handbook 3rd Edition<br />
<br />
Silakan download disini (<a href="http://adf.ly/FXCyL" target="_blank">http://adf.ly/FXCyL</a>) Anonymoushttp://www.blogger.com/profile/03193724019489170899noreply@blogger.com0