Description
RDBMS Specialist
Location: Brussels, Belgium
Duration: 03.04.2017 - 31.12.2017, extension possible (50-100% per week, overtime possible)
Languages: English
Rate: €60.00 per hour
For a client of ours in Brussels we are urgently seeking a RDBMS Specialist to start on 03.04 until at least the end of the year. You will set up the DB2 Database, automate the online backup and restore data as well as performance tuning and creating a materialized query table. Below you can find an example of instructions.
You have clear communication skills, the patience to explain DB2 administration activities and basic consultancy skills. You have a commitment to deliver, expertise and experience with DB2 administration and are ready to do overtime when necessary.
Are you familiar with this? Don't hesitate to get in touch with Sanne Wouters from Next Ventures by calling or e-mail your CV to (see below) with reference DB2BXL
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