Description
DB2 DBA - Brussels, Belgium - French speaking - 9 months +
One of our blue chip clients is urgently looking for a DB2 DBA.
Main language English
Second language French
Assignment percentage 50 to 100%
Job description summary Database specialist DB2
Responsibilities - Creation of Materialized Query Table
- Performance tuning
- Set up of DB2 database
- Automatisation of online backup and restore; refer to example of instructions
IT-Skills - DB2 database administration specialist
- Business Intelligence
Example of instructions:
ColdDB .99
Copy Z: 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
create and refresh MQT's
DB2 -stvnf C:/Users/gert.kraats/mqt_all.txt > C:/Users/gert.kraats/mqt_all_mde.out
DB2 GRANT DBADM ON DATABASE TO USER BO_DGHAN
Soft-Skills Basic consultancy skills
Clear communication
Patience to explain DB2 administration activities
Screening requirements - DB2 Administration expertise and experience
- Commitment to deliver
- Ready to do overtime when necessary
Please send CV for full details and immediate interviews, We are a preferred supplier to the client.