Monday, October 31, 2022

.::: Backup & Restore database IBM-DB2 DB2 :::.

›
 1. Introduction Backup and recovery methods are designed to keep our information safe. In Command Line Interface (CLI) or Graphical User In...
Thursday, October 27, 2022

.::: insert Query to test Replica SQL Server from Publisher to Subscription :::.

›
 continue from http://teguhth.blogspot.com/2021/10/how-to-install-replica-sql-server-mssql.html 1. run query -- run in primary/publisher sel...
Tuesday, October 18, 2022

.::: Create user, change password, change role & drop user , create user with specification limited access PostgreSQL EDB :::.

›
1. Create user su - postgres create user admin; ALTER ROLE admin SUPERUSER CREATEDB CREATEROLE REPLICATION; ALTER ROLE admin PASSWORD 'a...

.::: Query Check SQL Server Uptime MSSQL :::.

›
 1. Check SELECT @@servername as servername,getdate() as TimeCollect,sqlserver_start_time, DATEDIFF(Day, sqlserver_start_time,getdate()) as ...
Sunday, October 9, 2022

.::: Install IBM DB2 In Windows :::.

›
 

.::: Install IBM DB2 In Linux Centos 7 / Redhat 7 & check version Db2 :::.

›
  1. Extract * install DB2 [db2inst1@teguhth-grid ~]$ cd /data/ [db2inst1@teguhth-grid data]$ ls db2v11.5.7_linuxx64_server_dec.tar  server_...

.::: Study Kasus Praktis belajar Query create & insert table IBM DB2 (Create Data Warehouse) :::.

›
1. create user db2 in linux [root@teguhth-grid ~]# useradd teguh [root@teguhth-grid ~]# passwd teguh Changing password for user teguh. New p...
Wednesday, October 5, 2022

.::: How to identify DB2 port number Service & connect IBM Data Studio include error :::.

›
1. check for windows db2 get database manager configuration | findstr /i svce C:\Program Files\IBM\SQLLIB\BIN>db2 get database manager co...
Monday, October 3, 2022

.::: Archive table 6 months and 24 months SQL Server Using Copy import export write a query to specify the data to transfer :::.

›
A. Import using ssms 1. create table source create table pembelian_source( KODE_PEMBELIAN char(10), KODE_BARANG char(6),KODE_CUSTOMER char(6...
Monday, September 19, 2022

::: Enable Automate Startup/Shutdown of Oracle Database and Listener on Linux :::.

›
continue from https://teguhth.blogspot.com/2021/11/install-database-oracle-19c-in-linux.html 1. check /etc/oratab The Y on the end of the st...
Thursday, September 8, 2022

.::: List Index, size Index, unusage index, duplicate index & drop Index in SQL Server :::.

›
1. list index all use [AdventureWorks2019] go select @@servername as ServerName, db_name() as [DBName],object_id, name from sys.indexes wher...
Wednesday, September 7, 2022

.::: Load log file & insert into table in MariaDB MySQL (sample mariadb audit) :::.

›
  continue from http://teguhth.blogspot.com/2022/08/enable-server-audit-in-mariadb-mysql.html 1.    Create table tbl_mariadb_audit create da...
Wednesday, August 10, 2022

.::: Enable server audit in MariaDB MySQL :::.

›
  1.    Check plugin log [root@teguhth data]# mysql -u root -p Enter password: Welcome to the MariaDB monitor.  Commands end with ; or \g. Y...