Description
DB2 Database Specialist
For a client of ours in Brussels we are seeking an English speaking DB2 Database Specialist to be assigned % to this project, depending on the needs of the project as well as your availability.
Your tasks:
- - Creation of Materialized Query Table
- - Performance tuning
- - Set up of DB2 database
- - Automatisation of online backup and restore (see example of instructions below)
- - Create and refresh MQT's
Requirements:
- - DB2 Administration expertise and experience
- - Commitment to deliver
- - Ready to do overtime when necessary
- - Basic consultancy skills
- - Clear communication
- - Patience to explain DB2 administration activities
Here is an example of instructions:
ColdDB .99
Copy Z:online_backup TO E:/X/
DB2 CONNECT TO HANDIC USER s_Curam_DB2ADMIN USING "&_Ser_CdN"
DB2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
DB2 CONNECT RESET
DB2 FORCE APPLICATIONS ALL
DB2 DEACTIVATE DATABASE HANDIC
del E:/DB2/NODE0000/SQL00001/LOGSTREAM0000/*.*
del E:/DB_LOGARCH/DB2/HANDIC/NODE0000/LOGSTREAM0000/C/*.*
del E:/DB_LOGARCH/DB2/HANDIC/NODE0000/LOGSTREAM0000/C/*.*
DB2 "RESTORE DATABASE HANDIC FROM "x:" TAKEN AT 20170xxxxxxxxx LOGTARGET DEFAULT"
(Replace xxxxxxxxx with timestamp from the online backup)
DB2SET DB2_OVERRIDE_BPF=3,;2,60000
DB2 rollforward DB HANDIC to end of backup and stop
DB2SET DB2_OVERRIDE_BPF=
DB2 ACTIVATE DATABASE HANDIC
DB2 CONNECT TO HANDIC
DB2 UNQUIESCE DATABASE
DB2 CONNECT RESET
DB2 DEACTIVATE DATABASE HANDIC
DB2 CONNECT TO HANDIC USER s_Curam_DB2ADMIN USING "&_Ser_CdN"
DB2 ALTER BUFFERPOOL LOWMEM IMMEDIATE SIZE
DB2 update DB cfg using NUM_LOG_SPAN 0
DB2 update DB cfg using LOGSECOND -1
DB2 update DB cfg using LOGINDEXBUILD OFF
For immediate consideration please e-mail your CV with reference DB2