Mainframe System Education -- Wildfire Workshops

IBM is hosting no-charge workshops about new technologies, such as Java and Web-Sphere. You simply need to contact your IBM rep to have them enroll you. The follow-ing workshops are currently provided, but the list may change:
 CCLX1 - Cloud Computing on zEnterprise and System z
 LXOR6 - Customizing Linux and the Mainframe for Oracle DB Applications
 WBSR7 - WebSphere Application Server for z/OS Version 7
 WMB07 - WebSphere Message Broker for z/OS Version 7 Workshop
 WSW07 - Security Workshop: WebSphere Application Server for z/OS
 ZPRT1 - WebSphere Portal Server on Linux for zSeries Version 6.1
 ZJAV1 - z/OS JAVA Exploiters and JAVA Batch Workshop
 VC001 - Virtualization and Consolidation to Linux of System z
 WMQ07 - WebSphere MQ V7 and WMQ FTE for z/OS Workshop
 ZWPS6 - WebSphere Process Server V6.2 for z/OS Implementation Work-shop

Here is a direct link to their schedule and descriptions:
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS1778

Advanced Technical Skills - YouTube Video Flyer with Hyperlinks

IBM WebSphere Application Server for z/OS:

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4467

MySQL notes

Change a column name:
alter table tablename change oldname newname varchar (10) ;

Add a column to an existing table:
(1) ALTER TABLE contacts ADD email VARCHAR(60); to the end of the table
(2) ALTER TABLE contacts ADD email VARCHAR(60) AFTER name; the new column after a specific column
(3) ALTER TABLE contacts ADD email VARCHAR(60) FIRST; the new column to be first
(4) INSERT INTO table1 (col1, col2, col3) SELECT col1, col2, col3 FROM table2 WHERE col4='some value'; Copying rows from one table to another
(5) INSERT INTO settings_b SELECT * FROM settings_a WHERE account = 'bishop'; Copying rows from one table to another

Red Alert for All TCPIP users on z/OS 1.11, 1.12 using the QDIO Accelerator function

All TCPIP users on z/OS 1.11, 1.12 using the QDIO Accelerator function

Abstract:
A logic error in the QDIO Accelerator function in the base TCPIP code of z/OS 1.11, 1.12 can cause potential data loss.

Description:
TCPIP users with QDIO Accelerator enabled on z/OS 1.11 or z/OS 1.12 can experience a problem that may result in the potential loss of data when the accelerating path suffers a storage shortage condition. The accelerating path does not present any form of notification that a storage shortage condition has occurred.

Please see APAR PM37396 for additional details.

Recommended Actions:
Disable the QDIO Accelerator function until the ++APAR or corrective PTF can be applied. Please see APAR PM37396 for detailed instructions on disabling QDIO Accelerator.

If you want to have en overview of all past Red Alerts, then take a look over here. You can also subscribe on that same page so you'll be notified of any future Red Alert.