The Los Angeles Area DB2 Users Group (LAADB2UG) is holding a free, half-day DB2
workshop with Sheryl Larsen! The workshop will take place at the LAADB2UG
quarterly meeting on Thursday, December 3, 2009 in Costa Mesa. A repeat workshop
will take place on Friday, December 4, 2009 near LAX.

The workshop will include 90-minute session starting at 10:00 a.m. The topic
will be "DB2 9 & X for z/0S SQL Update". The afternoon will also consist of a
90-minute workshop starting at 12:30 p.m. The cross platform topic will be "How
and When to Change the DB2 Optimizer's Mind".

Registration includes all presentations, presentation materials and lunch.

There is no registration fee if you register in advance at
http://www.laadb2ug.org/.


RSVP by November 25, 2009 to reserve a seat, handouts and lunch.
To RSVP:  Send email to JaniceBies@...
Please include which session you wish to attend and the number of attendees

Greetings,

Our last meeting was not very successful in terms of membership attendance.

It is very important to the Staff of LAADB2UG that we are meeting the needs of
our membership, and we are asking for everyone's help in trying to find out what
we could do better in the future.

An anonymous online poll has been created, simply click the POLLS option in the
left hand column.

Please let us know the reason(s) for not attending our last meeting or any
meeting in the past.

# I cannot get the time off from work to attend.
# I prefer meetings during non working hours.
# I prefer information regarding DB2 on z/OS
# I prefer information regarding DB2 on LUW
# I prefer information regarding DB2 on AS/400
# The subject matter was not of interest.
# I was not aware of the meeting in a timely fashion.
# The Venue was not convenient.
# The parking was not convenient.
# I no longer have any interest in continuing with LAADB2UG.
# Other: Please explain


Your time and attention to this matter is GREATLY appreciated.

Thank you,
The Staff of LAADB2UG

Enter your vote today!  A new poll has been created for the
laadb2ug group:

Greetings,

Our last meeting was not very successful in terms of membership attendance.

It is very important to the Staff of LAADB2UG that we are meeting the needs of
our membership,
and we are asking for everyone's help in trying to find out what we could do
better in the future.

What are some of the reasons you did not attend the
September 2009 Meeting or have not attended any meeting
in the past?

   o The subject matter was not of interest.
   o I was not aware of the meeting in a timely fashion.
   o The Venue was not convenient.
   o The parking was not convenient.
   o I no longer have any interest in continuing with LAADB2UG.
   o I cannot get the time off from work to attend.
   o I prefer meetings during non working hours.


To vote, please visit the following web page:
http://groups.yahoo.com/group/laadb2ug/surveys?id=2900835

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!

Greetings,

Since we are now doing meetings on a quarterly basis, there are no membership
fees.

We are planning for a meeting the first Thursday of September at this time.

thanks,
John

--- In laadb2ug@yahoogroups.com, "db2info" <edbenoit@...> wrote:
>
>
> Hello,
>
> When is the next LA DB2 User Group meeting.  How do I re-join my
> membership?  Please send information to edbenoit@...
> <mailto:edbenoit@...>
>
> Cell 562-209-2937
>

Automating the recovery of DB2/zOS resources will benefit both the DB2 DBA and DB2 system programmers sections.

The GENDB2 software tool will benefit both sections.

0 DISASTER RECOVERY Feature: Complete DR testing is available at the Hot Site.  Complete or partial DR testing is available at your Local Site using a (DR) set of BSDS.  This will allow you to verify the generated Utility (1) JCL, (2) Control Cards, (3) RBA/LRSN Numbers, (4) pre-allocation of your User Tablespaces Image Copies VOLSERs and other resources before going to your Hot Site.   This will give you a warm fuzzy feeling before spending company resources/money.  A Local Site partial DR procedure is documented in the Operation Guide.

0 IDCAMS AUTOMATION Feature:  This feature automate the creation of the DB2 VSAM datasets for DB2 Catalog and Directory Tablespaces, User  Application Tablespaces, Active Logs, and BSDS.  Eliminate the need to Disk Pack Dump at Local site, and Disk Pack Restore at the DR site.   Save time and resources at both sites.

0 DR ARCHIVE LOG COPY RECORDING Feature:  This feature will record the output of your Archive Log Copy input/output.  At the DR site the Delete/Newlog control cards are automated to replace the BSDS information.  Archive Log copy Tape to Disk is also automated for faster tablespace recoveries.

0 SINGLE TAPE MOUNTING Feature: Single tape mount for multiple tablespace recoveries in same job On Site as well as Off Site.

0 PDS AUTOMATION Feature:  This feature automate the recording of your PDS type datasets (dsnload,dsnexit,runlib,dsnlink) backups and automate the recovery at the DR site.

0 HISTORY RECORDING Feature: History records on the recovery of your user tablespaces. All history records contain Tablespace Name, Type of Recovery, Timestamp, and Userid who submitted recovery job.

0 Dropped Tablespace Recovery Feature:

GENDB2 records all DBIDs, PSIDs, and OBIDs. No longer will the customer be required to run reports and key-in OLD and Current ID information.  All information (dbid, psid, all obids, input and output dsnames) are displayed on  ISPF panels for the user.

0 DSN1COPY using Image Copy to copy tables from one DB2 to another DB2:

Automated generation of JCL and Control cards for DBID, PSIB, and all OBIDs.

0 DB2 Data Cloning Feature:

Unload/Load - Copy all tables in a database from a DB2 to another DB2 using an EXCLUDE table with load restart ability.

Customer may also implement these jobs in production status.

0 COMPLETE DATABASE AUTOMATION Feature: Allow the user to generate recovery jobs for ALL Tablespaces and Indexes in a specified Database from a SINGLE panel.

1.       Recover (Forward, TOCOPY, TORBA) all Tablespaces in a database.

2.       Recover Tablespace Group (Forward) and TORBA using Archive Log Mode(Quiesce) RBA System Wide.

3.       Check Indexes and Data on all Tablespaces in a database.

4.       Image Copy all Tablespaces in a database.

5.       Reorganize all Tablespaces in a database.

6.       Quiesce all Tablespaces in a database.

7.       Modify all Tablespaces in a database.

8.       Repair all Tablespaces in a database.

9.       Report all Tablespaces in a database.

0 SECURITY Feature: Allow the user to restrict the use of specified features of the tool by Userid.

0 CUSTOMIZATION Feature: Allow the user to customize the recovery jobs by identifying all variable names in DB2 and ISPF Tables and skeleton members.

0 INSTALLATION:  GENDB2 can be installed in 4 hours or less.   No hooks, no authorized libraries and the software support multiple versions of DB2 concurrently. 

www.recoveryknowledge.com

Hello,

When is the next LA DB2 User Group meeting.  How do I re-join my membership?  Please send information to edbenoit@...

Cell 562-209-2937

Greetings,
Come and join us for a free briefing on DB2 9.5 and receive a free
Business Value Assessment for DB2 Compression! Find out how you can
save on storage costs without having to reorg your database.

DB2 Version 8.2 is going out of service on April 30, 2009. Now is a
great time to make sure your upgrade plans are in place. Whether you
are on Version 8 or Version 9.1, you'll find this session of interest.
Join us for this free Lunch and Learn session and find out about the
new features in DB2 9.5, migration services, and migration best
practices. We look forward to seeing you in Costa Mesa on March 5th,
or Glendale on March 6th.

Please check out the website at http://www.laadb2ug.org for more
information.

Hello-

Please  forward on to whomever is interested. Kaiser IT is an excellent place to
work with lots of opportunities.  We are seeking a Pasadena-based UDB expert to
join our Database Services Team:


Kaiser Permanente Information Technology (KP-IT) is seeking an established
database management professional with a strong understanding, and significant
experience in large scale, and highly complex data warehousing and transactional
data processing environments. A team player who will contribute to highly
visible projects such as Health Plan, Health Care, HRIS, Finance, IT
Infrastructure, Sarbanes-Oxley(SOX) initiatives, PCI compliance and HIPAA.


ROLE RESPONSIBILITIES:

* Act as a database planner across four database groups. Work with the entire
database organization of 70 DBAs to deliver comprehensive database solutions
supporting business functions, OLTP systems, Information Integration, Enterprise
Data Warehouse, Data Marts and other enterprise data stores.
* Produce and maintain the database system architecture blueprint composed of
user interface, web server, application layer, database server, connection
layer, and operating systems; as appropriate for OLTP and decision support
environments.
* Participate with the database managers and team leads to develop strategic
directions for DBMS infrastructure/architecture design and solutions, including
DBMS platform, DBA productivity tools, DBMS utilities, database monitoring,
database connectivity, and DBMS access tools.


BASIC QUALIFICATIONS:

* 10+ years of recent Database Administration experience
* 7+ years of recent Database development and production support experience in a
large (100 GB+) 24 x 7 UDB LUW environment
* Implementation experience with UDB LUW, DPF
* Replication setup experience utilizing various technologies based on user
requirements

Required skills:
* UDB LUW, DPF, UDB V5/6/7/8/9 database administration.

RDBMS:
UDB LUW


"In my opinion, the best thing you can do is find a person who loves you for
exactly what you are. Good mood, bad mood, ugly, pretty, handsome, what have
you"

-from the movie Juno

The next meeting of the LAADB2UG will be on Thursday, Sept 4th, 2008.

Robert Andresen will be our featured speaker.

We will be meeting at the CA offices, 6100 Center Dr. Suite 700 Los
Angeles 90045. The CA Office is just off the 405 and Howard Hughes
drive by the Bridges Mall in the Pepperdine building.

Park in the parking lot near the building and CA will pay for parking.

Meeting Schedule

08:30 - Doors open for coffee and refreshments.
08:45 - IBM comments and announcements.
09:00 - Robert Andresen on "Excelling at DB2 Monitoring and Reporting"

Robert Andresen is a Technology Specialist with CA. He has been
working in performance management and monitoring for several software
companies since 1997 and has been supporting mainframe systems since
1976. He is a co-author of the IBM Redbook: Linux on IBM @server
zSeries and S/390: System Management. He holds a degree in Mathematics
from the Illinois Institute of Technology. At CA he supports their
suite of DB2 for z/OS tools. His areas of expertise include z/OS, DB2,
Oracle, CICS, UNIX/Linux, Windows, Websphere MQ and Networking...


Excelling at DB2 Monitoring and Reporting

Most DB2 monitors can load accounting and statistics data into DB2
tables. We can use spreadsheets as an adhoc reporting against this
data. Statistics rows show usage of critical resources during peak
times and accounting rows show which applications are consuming the
critical resources.

We will build an inventory of tables and column names and generate
SELECT statements from a Rexx exec. Each of our spreadsheets will be
focused on a related group of metrics over a meaningful time frame. We
will then subtotal, summarize and graph the data, building DB2
performance dashboards.

You should find everything you need on the First page, please let me
know if you have any issues.

Thanks,

John

John Carter  |  LAADB2UG VP & Webmaster  |  http://www.laadb2ug.org
"Reason and free inquiry are the only effectual agents against error." -
  Thomas Jefferson

Hi Bryan,

I have never been a big fan of the GUI frontends that IBM has decided
should be placed in front of install / fixpack scripts so if it were
me, I would forgo the db2set and use the db2_install instead.

Now granted it will take more work as all db2_install does is install
the packages, so you will have to build the instance and the db2admin
node, create users, do the db2set stuff, yada, yada, yada, but at
least IF the script fails you get a much better error code than
"ooops, something busted!"

However, back to the original question. Since we all love the pretty
little GUI screens, make sure first that your services for such pretty
graphics is up and running. Sometimes it is the graphics card itself
that will not support x-windows type emulations.

You can also check your various Unix logs for any errors and the db2
install log may offer some help(emphasis on MAY), let us know how it
goes and if we can be of any more help.

Thanks,
John

--- In laadb2ug@yahoogroups.com, "Bryan O'Neal" <boneal@...> wrote:
>
> I am trying to install db29.5 Express -C onto a new server (Cent OS5)
> when I go to run ./db2setup it spits back  "DBI1190I db2setup is
> preparing the DB2 Setup wizard which will guide you through the program
> set up process. Please wait." but instead of launching the window it
> just kicks me back to the terminal prompt.  Any one ever seen this?
>

Hi Jim,

We are usually done around noon, hope to see you there.

Thanks,
John

         …jc

 
Jim Carr, Manager, Information Management
CaPES Application Infrastructure Services

Enterprise Engineering, KP-IT
Internet Email: jim.a.carr@...
Desk: 626-564-7545 | Cell: 626-622-1121

NOTICE TO RECIPIENT:  If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents.  If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them.  Thank you.

Meeting Information for June 2008
Auto Club will be ordering Food & Drink for the User Group Meeting. G
& H Conference Room holds 50 People. Proxima & Display Screen
reserved. A couple of tables for Food & Drink, & literature.
The next meeting of the LAADB2UG will be on Thursday, June 5th, 2008.
  Craig Mullins will be our featured speaker.

It will be held at the
3333 Fairview Rd, Costa Mesa, CA 92626

Click here for directions and a map.


Meeting Schedule

08:30 - Doors open for coffee and refreshments.
08:45 - IBM comments and announcements.
09:00 - Craig Mullins on "A DB2 Performance Tuning Roadmap" and
"Database Trends 2008"



Craig S. Mullins is a data management strategist, researcher, and
consultant. He is currently employed as corporate technologist for
NEON Enterprise Software. Craig has more than two decades of
experience in all facets of database systems development including
developing and teaching DB2 and SQL Server classes, systems analysis
and design, database administration and system administrator, and data
analysis and modeling. He has worked with DB2 for z/OS and OS/390
since Version 1 and has experience working with Microsoft SQL Server,
Sybase and IMS. Craig has worked in multiple industries including
manufacturing, banking, commercial software development, education,
research, utilities, and consulting.



A DB2 Performance Tuning Roadmap


  DB2 performance from application/SQL, database, and system
perspectives of everything you'd want to ask about DB2 performance.




Database Trends 2008


Key topics covered include:
* The Tuning Progression: development versus maintenance
* Application Tuning: application code and SQL
* Database design and implementation: DDL, indexing, and organization
* System Tuning: DB2 subsystem issues
* The Environment: OS, TP, Network

Directions:               405 Fwy - Take Fairview Exit North, then
turn left (west) on South Coast Drive.  Auto Club will be on the
right.  Go into 2nd driveway on
the right where the parking lot security arm  will be open.  At the
first stop sign, turn left.
Park in any available space.  This is the Employee parking lot.

  Directions to G & H Conference Room:

Head back toward the Auto Club office buildings near the Stop sign.
The nearest building is the Cafeteria, where G & H Conference rooms
are. Enter the Cafeteria building and go toward the hall way.  Before
exiting the Cafeteria, there will be a  all on the left, which is the
entrance to the G & H Conference Rooms.  These rooms are adjacent to
the employee store.



BACK TO THE HOME PAGE




      Find out more about UDB Benchmarks here.

Website created and maintained by DataDoneRight.Com
Copyright © 2001-2006. All rights reserved.
Join the Anti-Spam Resistance Movement

Location
IBM
600 Anton Blvd.
Room 221
Costa Mesa, CA 92626
Parking in Structure (must pay for parking)
Parking at South Coast Plaza (FREE, walk accross bridge)

DAMA (The Data Management Association) has a chapter in Southern California.  We
are a
not-for-profit, vendor-independent, group of data architects, data
administrators, data
analysts, and managers of the above.  We do not usually have DBA's as members,
except
insofar as they are responsible for logical (as well as physical) database
design.

We would like to invite your members to visit our Website:

http://www.dama.org/public/pages/index.cfm?pageid=319

and to call our existence to the attention of the persons within their
organizations who are
most directly concerned with these issues.

Thanks,

Mark Wallace, President
DAMA-LA Chapter

Hi Folks:

I have a v8.2 UDB installation on Win2003 Std server.  I've configured
for automatic maintenance, including a backup that is supposed to run
every night.  I configured the options to force a daily backup.  Any
ideas as to why nothing seems to be happening?

Thanks... Tim

Absolutely Tim,

Was there something specific you wanted to discuss?

John
--- In laadb2ug@yahoogroups.com, "timmbrodie" <tmbrodie@s...> wrote:
>
> Hi:
>
> Is this a good forum to ask technical advise?
>
> Thanks... Tim
>

Hi:

Is this a good forum to ask technical advise?

Thanks... Tim

Recovery Knowledge is please to announce an enhanced version 5.0 of
the GENDB2 software product.  GENDB2 is a software product that
automates the recovery of DB2 for OS/390-z/OS resources Off-site
Disaster Recovery as well as On-site and automates many utilities
used by the DB2 DBAs and DB2 System Programmers.  The enhancements to
the GENDB2 software product include:

DSN1COPY – Using Image Copies to copy tablespaces from one DB2 to
another.  Automated generation of JCL and Control cards for DBID,
PSIB, and OBIDs
(1) To same DB2.
(2) To another DB2 with all IDs on same complex sharing datasets.
(3) To another DB2 with all IDs on another complex NOT sharing
datasets.
(4) Check
(5) Print
RECOVER SAP TABLESPACES – Or Grouping of any DB2 Tablespaces.
(1) Recovery Forward
(2) Recovery TORBA using System Wide Quiesce RBA residing on BSDS.
UNLOAD/LOAD  The unloaded information tables and control cards is now
stored in DB2 tables allowing the customer to retrieve and load
tables as far back as the first unload using the GENDB2 software.
UNLOAD – Option to take backups of unloaded data and control cards to
be used at Local site or Remote site.
UNLOAD –  Now GENDB2 will do the BLDG for SYSPUNCH and SYSRECXX to
create generation data groups for these tablespaces unloaded tables.
UNLOAD –  The customer may now implement the UNLOAD GENDB2 generated
jobs into production status.
LOAD – Now the customer can do a restart of the Load process in case
of abends.
LOAD – Now the customer can select only certain tables to be loaded
when tables are destroyed.
LOAD –  The customer may now implement the LOAD GENDB2 generated jobs
into production status using the Exclude table to exclude specified
tables based on target DB2id and target database.
Enhanced DR - Feature to allow the customer to display GENDB2 tables
regarding Disaster Recovery.
(1) The Archive Log Copy recording information (Original and
Copied volume serial numbers, and data set names (BSDS and Archive)
with TIMESTAMP can now be displayed.
(2) Display Start/End RBA and LRSN for latest Archive Log
Registration.
(3) Display Conditional Restart CRestart
(4) Display Start RBA for DSN1LOGP

For free information, please visit http://www.recoveryknowledge.com
On the left side of the web page, select REQUEST FREE INFO.  When
prompted to select a subject, chose PICK A SUBJECT.  For additional
information, e-mail db2tech@...