ChannelDB2

Information

DB2 for z/OS

Group for those with interest in DB2 on System z.

Website: http://channeldb2.ning.com/group/db2forzos
Members: 91
Latest Activity: Mar 11

Title: Reduce costs, increase capacity & availability with DB2 Data Sharing ! Feb 24th 2009
Date: Feb 24th, 2009
Time: 11:00 EST , 16:00 GMT
Register Now

Visit The World of DB2 for z/OS

Discussion Forum

DB2 10 Migration Month!

Started by Laura Hood Oct 17, 2011.

DB2 Utilities vs Programs

Started by Gary Allorto Apr 1, 2010.

Pre-certification class for test 737: DB2 9 System Administration for z/OS ? 9 Replies

Started by Susan Visser. Last reply by Sridhar Jan 8, 2010.

Comment Wall

Comment

You need to be a member of DB2 for z/OS to add comments!

Comment by Jose Luis on December 15, 2011 at 11:37am

Hi:

In IBM Mexico we are looking for an DB2 Database Administrator. The person in this position will have two to three years of experience and strong technical experience. Please find the full job description for this position on our website: http://www.ibm.com/mx/employment/  Job Code ITD-0409585

Comment by Rodolfo on May 4, 2010 at 12:11pm
Weiler, here it is the requestes SQL

SELECT SUBSTR(COLUMN,LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1,(LOCATE('-',COLUMN,LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1))-(LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1)) FROM SCHEMA.TABLE;
Comment by Rodolfo on May 4, 2010 at 11:43am
Hello everyone,

Does anyone in here is 000-737: IBM Certified System Administrator - DB2 9 for z/OS?

I passed on that exam, so I'm looking forward to know how was it for you?

For me, it was not that hard, although you need to study to be better prepared.
Comment by Weiler Gonçalves Monteiro Junior on March 11, 2010 at 9:44am
Hellow Word!
Gostaria de saber como fazer uma consulta e retornar o conteúdo que está entre traços.
ex:
1º 2º 3º
XXYYY-XXXYYY-12345-XXXYYYZZZ
no caso acima gostaria saber como fazer uma consulta para retornar os valores que estão entre o 2º traço e o 3º traço.
no caso acima o resultado seria 12345. mas poderia ser qualquer outro valor.
como fazer uma consulta para ter esses valores, independente do tanto de caracteres que possua entre os traços... em um caso poderia ser 5 caracteres como no caso acima, mas em outro poderia ser 10 caracteres... por isso me interessa o resultado que exista entre os traços.
desde já agradeço.

Weiler
Comment by Weiler Gonçalves Monteiro Junior on November 18, 2009 at 7:56am
Hi,
I install an simulator of the mainframe(Hercules). that have 13 GB.
Now I want configure DB2 for start with mainframe and put in prod.
God by!
Comment by Surekha Parekh on October 19, 2009 at 7:50am
Don't Miss Upcoming web event on Nov 3rd 2009
Reduce CPU & Stay one step ahead - DB2 X for z/OS Technical Preview


Broadcast Date: November 3, 2009 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. UTC

Developed for: IT Managers, Application Architects, DBA, System Administrator, System Programmer System architects.

Technical Level: Intermediate

DB2 X has a lot for everyone. Your organization needs to lower operating costs thru CPU cycle reductions while still building a strong foundation for SOA and XML initiatives. Database Administrators (DBAs) will find improved database performance, scalability, and availability. Memory management is dramatically reduced, so growth is much simpler. DBAs also get more flexible security to help with regulatory compliance. A wide range of enhancements improve ERP application and data warehouse functionality and performance. Large object (LOB) performance and flexibility are improved. Many DBA tasks are simplified.

Application developers will be most excited by the second release of pureXML, which improves the SQL and XML interface to access XML data stored in a native format. Application developers need powerful new SQL enhancements. Improved SQL and data definition compatibility with other DB2 platforms makes porting much easier.

Speaker: Jeff Josten, Distinguished Engineer, DB2 for z/OS Development
Comment by Weiler Gonçalves Monteiro Junior on October 2, 2009 at 6:35am
Friends
someone has anything about Power Center of enterprise CA ? may be pdf, apresentation, dvd, etc... tool free seem that make same thing.
Comment by Sabine Kaschta on March 5, 2009 at 10:23am
Insterested in learning more about XML? Come visit our two different XML workshops!
1) CV120: DB2 9 for z/OS - Query XML data (http://www-304.ibm.com/jct03001c/services/learning/ites.wss/zz/en?pageType=tp_search_results&rowStart=0&rowsToReturn=20&searchString=cv12)
2) CV260: DB2 9 for z/OS - Manage XML data (http://www-304.ibm.com/jct03001c/services/learning/ites.wss/zz/en?pageType=tp_search_results&country=zz&rowStart=0&rowsToReturn=20&searchString=cv26)
Comment by Sabine Kaschta on February 20, 2009 at 4:23am
The first US teach for brand new 3-day course 'CV970 - DB2 9 for z/OS - Spotlight on zParms' will be held starting May 13, 2009 in Santa Clara, CA.
To enroll and to learn more abou it, follow this link:
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&courseCode=CV970
Comment by Surekha Parekh on January 13, 2009 at 6:36am
We have 2 new web events for DB2 for z/OS coming up in Jan & Feb - please feel free to register. Here are the URLs
1. Business Benefits of DB2 Stored Procedure & Web 2.0; Jan 27, 2009
http://www-01.ibm.com/software/os/systemz/telecon/jan27/

Reduce costs, increase capacity & availability with DB2 Data Sharing! Feb 24, 2009
http://www-01.ibm.com/software/os/systemz/webcast/feb24/

I am planning webcasts for 2009 so please let me know what you would like us to present on in 2009.
 

Members (91)

 
 
 

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service