SpDUG organiza durante los días 22, 23, 24 y 25 de Junio cuatro seminarios de día completo impartidos por Cristian Molaro, consultor DB2 independiente e "IBM Gold Consultant".
Los interesados en asistir a los seminarios deben inscribirse en el siguiente formulario. SpDUG se pondrá en contacto con la persona interesada para formalizar la inscripción y proporcionar los datos de pago. La tasa de inscripción es de 350€ por 1 seminario, 600€ por 2 seminarios, 800€ por 3 seminarios y 950€ por los cuatro seminarios e incluye los materiales del curso, café y almuerzo. A las personas que asistieron a los seminarios del año 2014, se les aplicará un descuento del 10% en cualquiera de las modalidades. Los seminarios se impartirán en español en el Hotel Meliá Avenida América, Calle de Juan Ignacio Luca de Tena, 36, 28027, Madrid en horario de 09:15H a 17:15H. El hotel dispone de un servicio de transporte gratuito aeropuerto-hotel-aeropuerto entre las 06:00H y 23:30H. La comida tendrá lugar en el mismo hotel.
Seminario A - 22 Junio 2015
DB2 for z/OS Recovery in depth
This session covers DB2 for z/OS recovery in-depth and provides and update on the state of the art for DB2 backup and recovery. It provides a refresh on what to do, and what not to do. It also discusses common errors and pitfalls to avoid. It gives an update on what is new in DB2 for z/OS version 11 in recovery matters.
- Introduction to DB2 recovery
- Common recovery exposures to avoid
- Backup strategies
- Recovery planing
- Utility considerations
- Utilities for data integrity
- Utilities for backup and recovery
- DB2 Catalog and Directory recovery considerations
- System backup and system restore
- BSDS topics
- Data sharing considerations
- What is new in DB2 10 for z/OS
- What is new in DB2 11 for z/OS
- Must know about DB2 11 extended RBA and LRSN
Seminario B - 23 Junio 2015
Moving and cloning DB2 data
This session discuses about the techniques, possibilities, and best practices about moving and cloning DB2 for z/OS data.
- Overview of moving data across the DB2 family
- Overview of the DSN1COPY, DSNTIAUL, REORG, UNLOAD, LOAD utilities
- DB2 High Performance Unload
- DB2 Cross-loader
- DB2 System backup and restore
- DB2 Clone
- Replication tools
- ETL vs ELT
- Cross platform data movement overview
- DB2 Federation
- Common practical scenarios
- Best practices
Seminario C - 24 Junio 2015
Introduction DB2 LUW for experienced DBA’s
This seminar is designed to leverage your database and IT skills into the world of DB2 for Linux, Unix, and Windows. Cristian will discuss the basis of how DB2 works, what you need to know to get started as best as possible, and what are the common mistakes to avoid. He will highlight the differences and similarities with other databases, and will show the best ways of getting more information. A pragmatic approach that focuses on helping you to become a proficient DB2 professional in a more efficient way. This presentation covers current DB2 releases. Are you a DB2 for z/OS, SQL Server, Oracle experienced user looking for a fast path into DB2? This day has been created for you! Cristian will teach you the major commands and differences with other databases
- Introduction to DB2
- What is DB2 for Linux, Unix, and Windows?
- DB2 editions & DB2 licensing
- DB2 LUW vs. DB2 for z/OS
- The DB2 architecture
- Instances and databases
- Table Spaces
- Tables, Indexes, and Large Objects
- DB2 logging
- Buffer Pools
- Storage Groups / Automatic Storage
- Table compression
- The DB2 working environment
- DB2 Command Line Processor (plus)
- IBM Data Studio and other GUI tools
- Application enablement
- Default locking settings
- Working with packages
- SQLJ and pureSQL
- Java development considerations
- The DB2 Advisors
- SQL for cross-platform development
- The DB2 deployment options
- High Availability (HADR) and PureScale
- BLU for analytics
- Interaction with DB2 z/OS and other databases
- System topics
- Installing, updating and upgrading DB2
- IBM Data Server Clients and Driver Packages
- Automatic Database Maintenance
- Using database tools and utilities
- Backup and recovery at a glance
- Performance tools at a glance
- Security topics
Seminario D - 25 Junio 2015
Mastering Linux for IT Professionals
Linux is a prime option when looking for decreasing operating system costs and increased security, among many other solids arguments. The usage of Linux in production environments is in permanent expansion: mainstream commercial adoption by enterprises and governmental organizations are common news nowadays. It is very common, then, to find oneself becoming a Linux user from a day to another.
This one day seminar is designed to help you to break the Linux entry barriers and to make you feel at home working with Linux. It explores the various tools and techniques commonly used by programmers, system administrators, and end users to achieve their day-to-day work. Upon completion of this training, you should have a good working knowledge of Linux from both a graphical and command line perspective.
Cristian will discuss industry professional best practices to leverage the Linux potential and to get you started on the right path. He will also demystify Linux by exposing its strengths and limitations to help you to understand its true potential.
The class is designed for people who have limited or no previous exposure to Linux. System administrators, developers, architects, decision makers or new Linux users can all benefit from the content covered in this class. In addition, current Linux users can benefit as well from a large scope of Linux topics and from an industry best practices discussion.
- What is Linux?
- The Linux Shell and the Command Line Interface
- Linux File System
- Performance and capacity planning
- System administration
Cristian Molaro is an independent DB2 specialist and an IBM Gold Consultant. He was recognized by IBM as an Information Champion in 2009, 2010, 2011, 2012, 2013, 2014, and 2015. His main activity is linked to DB2 for z/OS and LUW administration and performance. He has presented papers at several international conferences and local user groups in Europe and North America. He is coauthor of 9 IBM Redbooks related to DB2 including the recent "DB2 11 Performance Topics". He also contributed as a Technical Editor in IBM's "DB2 Essentials" by Raul Chong and Clara Liu. Cristian is past-Chairman of the IDUG EMEA Conference Planning Committee, and he is Chairman of the DB2 LUW User Group BeLux. Cristian was recognized by IBM as "TOP" EMEA Consultant in 2011 and 2013.He can be reached at
Hotel Meliá Avenida América, Calle de Juan Ignacio Luca de Tena, 36, 28027, Madrid.