Saturday, 14 September 2013

Unmissable course coming up! IBM DB2 FOR I SQL PERFORMANCE MONITORING AND TUNING WORKSHOP starting 24th September in London

If you have anything whatever to do with DB2 for i and you haven't previously attended this fantastic course, can I encourage you to consider attending? I did so myself in 2009 and have benefited greatly ever since.

Here's some more information:

IBM DB2 FOR i SQL PERFORMANCE MONITORING AND TUNING WORKSHOP (OD40AGB) 

This class will be taught by Jim Denton who is an experienced and highly skilled specialist from the IBM DB2 for i Centre of Excellence based in Rochester, US. Jim is one of the original authors of the SQL Performance Workshop and has been delivering this course, around the world since 2003.

Learn the information, tools and strategies for monitoring, analyzing and tuning IBM DB2 for i Structured Query Language (SQL). Explore the science and art behind the DB2 for i query optimizer and database engine, including database performance and scalability. Discuss performance issues affecting database design and data-centric applications. Get hands on experience with database performance parameters and options, as well as the various tools that assist in performance monitoring, analysis and tuning. Knowledge and skill gained by attending this course are considered critical success factors when building and deploying SQL based solutions.

More details:
http://edu.arrowecs.eu/uk/trainings/open/ibm-db2-for-i-sql-performance-monitoring-and-tuning-workshop/395921/training_sheet.html

Duration: 3 days
RRP: £1,700.00 per person (exc.VAT)
Date: 24th September 2013
Location: Arrow ECS London Office, Entrance 2, Fourth Floor, The Royal Exchange, London EC3V 3LN

Saturday, 7 September 2013

i-Community Trip to IBM Rochester: Fantastic Agenda

Looking forward to setting off for what promises to be a superb event as always.

Wednesday 11 September, Executive Briefing Center
08:45     Continental Breakfast
09:00     Welcome and Introductions, John Rathke, World Wide Briefing Project Manager
09:15     IBM i Update and Directions, Steve Will, Chief Architect, IBM i
10:15     Break
10:30     DB2 for IBM i Discussion, Mike Cain, Team Leader DB2 for i Center of Excellence
11:45     Luncheon
12:45     PowerVM, Kris Whitney, Power Virtual I/O, SAN, Comm Development
13:45     PowerHA, Steve Finnes, Power Systems HA Product Offering Manager
14:45     Break
14:55     IBM i Storage Solutions, Nick Harris, SWG CPO, Storage Team Lead
15:55     Break
16:05     POWER Systems Update and Directions, Mark Olsen, Power System WW Product Management

Thursday 12 September, Executive Briefing Center
08:45     Continental Breakfast
09:00     IBM Director for IBM i, Tim Rowe, Business Architect of Application Development for IBM i
10:00     Break
10:15     Application Development Directions, Tim Rowe
11:30     Luncheon
12:30     Energy Management, Brad L. Brech, IBM Distinguished Engineer, STG Strategy Team and Architecture Board
13:30     Security – TKLM, Key Manager
14:30     Break
14:45     Performance Tuning – Awareness of iDoctor

Friday 13 September, Executive Briefing Center
08:45     Continental Breakfast
09:00     i25 and Lab Services Responsibilities, Ian Jarman, Apollo Category Marketing
09:45     BRMS – Backup and Recovery, Parallel Saves, Encrypted Backups, David R. Bhaskaran, BRMS Development
11:00     Electronic Support, Paula R. Fulton, Business Analyst, Electronic Support Transformation
12:00     Luncheon
12:45     Fix Support, Paula R. Fulton

Sunday, 9 June 2013

Music of a Killer Prince: Chandos Singers of Bath, Saturday 6th July

Music of a Killer Prince
A concert marking the 400th anniversary of the death of the great Italian composer Carlo Gesualdo

The Chandos Singers, conducted by Malcolm Hill, are one of Bath’s leading chamber choirs.

The concert will begin with a celebration of the 850th anniversary of the laying of the foundation stone of Notre Dame Cathedral. The Notre Dame School produced the first multi-part sacred works to be known internationally, thereby having a significant influence on the development of Western music.

Carlo Gesualdo (1560-1613), Prince of Venosa, is known for two things: the fact that in 1590 he murdered his wife, and the passionately expressive and extraordinarily innovative choral music on which he worked for the rest of his life. Many have suggested that the two are linked. The Chandos Singers will be performing some of the most beautiful of his sacred works: Deus refugium, Reminiscere miserationum, Ave, dulcissima Maria, Gaudeamus omnes, Peccantem me, and Ave sanctissima.

The choir will celebrate the 60th anniversary of the Coronation of Queen Elizabeth II by singing a selection from A Garland for the Queen, commissioned from British composers by the Arts Council for performance on the eve of the Coronation. The Chandos Singers have chosen to perform the works by Ralph Vaughan Williams, Gerald Finzi, Edmund Rubbra, and John Ireland.

The programme is completed by a dramatic setting from the contemporary Finnish composer and linguist Jaakko Mäntyjärvi of Double, double, toil and trouble from Macbeth.

The concert will be held in the serene surroundings of the Magdalen Chapel on Holloway, Bath. A chapel is known to have existed on this site in the 11th century, and a leper hospital was built close by in the 12th. Both were under the care of the Abbey monks. The current building is 15th century. Despite severe bomb damage in 1942, it remains an active centre of worship.

Interval refreshments can be enjoyed in the Chapel garden, which has spectacular views over Bath.

Saturday 6th July 2013, 7.30pm
The Magdalen Chapel, Holloway, Bath BA2 4PX

Tickets: £12, students £6
Bath Box Office: 01225 463362 | boxoffice@bathfestivals.org.uk

Online bookings
https://uk.patronbase.com/_BathFestivals/Productions/CS2/Performances

Further details
Mandy Shaw 01225 436302 | mandy.shaw@iperimeter.co.uk

Chandos Singers
www.chandos-singers.co.uk
Magdalen Chapel
www.magdalenchapelbath.co.uk

Monday, 28 January 2013

Fantastic opportunity for IBM i people in the UK

The IBM DB2 for i SQL Performance Monitoring, Analysis and Tuning workshop will be held in London the week of 25 Feb. The excellent Mike Cain from the DB2 for i Center of Excellence - Rochester, Minnesota will be the instructor. More information about enrollment is here: http://www.edu.arrowecs.eu/uk/trainings/open/ibm-db2-for-i-sql-performance-monitoring-and-tuning-workshop/1672/training_sheet.html (I went on this course in 2009 and cannot recommend it too highly.)

Sunday, 26 August 2012

#ibmi hints and tips #17: About reusing deleted records

I have been caught out so many times on this one ... If you create a physical file with CRTPF (whether using DDS or not), the default setting is REUSEDLT(*NO). If you create it using SQL, the default is REUSEDLT(*YES).

Tuesday, 14 August 2012

Interested in becoming a member of the IBM Electronic Support Client Advisory Panel?

I've been asked to publicise this IBM initiative for those with an interest in online technical support.

The Electronic Customer Support Advisory Panel meets on the 'phone every other month to review future plans for electronic support and to provide input about what they need from the Support web site.

This would take up about an hour every other month.

Participating gives members the opportunity to influence the enhancements and changes IBM makes to its electronic support; it also gives IBM a better understanding of what customers need and want in the next generation of support, and how IBM can address them.

If you're interested, I have more details and the necessary IBM contact information - you can get in touch with me at mandy.shaw@iperimeter.co.uk.

Friday, 10 August 2012

#ibmi hints and tips #16: A small fact about CPYTOSTMF and CPYTOIMPF

I have only recently realised the simple fact that CPYTOSTMF and CPYFRMSTMF work with 'program described files' (as IBM i still, scarily, calls them), i.e. physical files created using CRTPF without DDS, while CPYTOIMPF and CPYFRMIMPF work with proper database files, i.e. physical files created using either DDS or a SQL CREATE TABLE. I'm sure you were all aware of this, but just in case ...