DB2 Queueing Models

DB2 Queueing Models

Post by William Hawthor » Sat, 25 Mar 1995 10:53:52

Has anyone done any classic queueing theory modeling of DB2 requests? I'm
researching a scenario where hundreds of interactive users of an
application will be performing SELECTs against a single table, sharing an
(as yet) indeterminate number of open threads. For simplicity, assume
that only DB2 and the relevant application are running on the processor,
and that the only DASD contention is due to inter-thread conflicts. Also
assume that each user SELECT is no more complex than any other, and the
requests are Poisson distributed.

Some questions come to mind:

   Is M/M/1 queue modeling appropriate?

   Does DB2 ever decide that a maximum number of threads may be active at
   one time -- or are they all multitasked with equal priority? If DB2
   imposes a maximum, is the dispatching arranged in a queue?

   Are the only "servers" (in the queueing modeling sense of the term) DASD
   and the threads?

Newsgroups: bit.listserv.db2-1
Subject: DB2 Queueing Models
Distribution: usa
Organization: Texas Metronet, Internet for the Individual  214-705-2901 (info)


1. VA-Alexandria-265567--CASE Tools-ERWin-Data Modeling-RDBMS-SQLSERVER-DB2-CA-DATA

******** VISIT US AT http://www.selectjobs.com ***********
Company    : CareerMagic
Website    : http://www.careermagic.com
Job Title  : Data Analyst
Location   : Alexandria, VA
Job Type   : Contract or Full-Time Salaried

A Data Analyst position is available for Corporate Data Sharing to support
Enterprise Analysis. The successful candidate will perform logical and physical
data modeling, applying corporate data standards. Familiarity with database
administration and requirements analysis are required, along with strong
systems analysis and planning skills.

The successful candidate will conduct data analysis and logical data modeling
tasks, and review logical data models to ensure corporate standards are
followed and the logical model is correctly structured. Strong skills in the
following are desired:

<ul><li>Data analysis;<li>Data normalization;<li>Translation of logical data
models to physical data models;<li>CASE tools, preferable ERwin, Cayenne, or
ADW;<li>Data definition and naming standards; and<li>RDBMS: SQL/Server, DB2,
CA-DATACOM/DB, Oracle, or Access.</ul></font> -

Travel Required          :None
Educational Requirements :None
Required Skills
* CASE Tools
* ERWin
* Data Modeling
* DB2
To apply to this position connect to www.CAREERMAGIC.com and confidentially
submit your resume and profile.
Contact Information:
Reference : _0220HQARS-39

***********************  http://www.selectjobs.com  ****************************

                The On-Line, On-Target Job Finder for Computer Professionals  

** Post Your Resume and see results immediately!! ** Always free **
** Matching Resumes E-mailed daily
**  Your ads are virtually guaranteed to be seen by jobseekers on the NET **

                    ** Automatic Posting to **
   ** Yahoo            ** Americas Job Bank    ** AltaVista   *** ClassifiedsWarehouse
   ** erpcentral.com   ** Classifieds 2000     ** Usenet Newsgroups
           ** VBOnline.com   ** ORASearch.com  
               *** OVER 100 MILLION HITS/MONTH COMBINED !!! ***

***********************  http://www.selectjobs.com  ****************************

2. New SQL Server CE Security Whitepaper Available

3. VA-Alexandria-103758--Data Modeling-CASE Tools-ERWin-ADW-DB2-MS ACCESS-ORACLE-CA

4. Distinct Issue

5. 39451-GA-Atlanta-Data Warehousing-Data Modeling-Database Design-DSS-RDBMS-DB2-OR

6. Trigger row as parameter for procedure call?

7. 16298-FL-BOCA RATON-Data Modeling-Informix-ORACLE-IDMS-Project Management-DB2-IT

8. PL/SQL Tip of the Month