1 Midwest Mfg/Pro User Group Click to edit

1 Midwest Mfg/Pro User Group Click to edit

1 Midwest Mfg/Pro User Group Click to edit Master title style The Progress Myth Detectives Presented by: Dan Foreman ([email protected]) PUG Challenge Americas 2014 2 Our Mentors PUG Challenge Americas 2014

3 Introduction Dan Foreman Progress User since 1984 Author of several Progress related Publications Progress Performance Tuning Guide Progress Database Administration Guide Progress VST & System Tables Author of several useful Progress DBA Tools

ProMonitor & ProCheck & LockMon Pro Dump&Load Balanced Benchmark Basketball & Bicycle Fanaticwhich sometimes leads to unexpected trips to the Emergency Room PUG Challenge Americas 2014 4 PUG Challenge Americas 2014 5

My New Wheels (so I wont fall over) PUG Challenge Americas 2014 6 Wikipedia definition of Mythology The term mythology can refer either to a collection of myths (a mythos, e.g., Inca mythology) or to the study of myths (e.g.,comparative mythology).[1] According toAlan Dundes, a myth is a sacrednarrative explaining how the world and humankind assumed their present form,[2]although, in a very broad sense, the word can refer to any traditional story.[3] Bruce Lincoln defines myth as "ideology in narrative form".[4] Myths may arise as either truthful depictions oroverelaborated accounts of historical events, as allegory for or personificationof natural

phenomena, or as anexplanation of ritual. They are used to convey religious or idealized experience, to establish behavioral models, and to teach. Early rival classifications of Greek mythos by Euhemerus,Plato's Phaedrus, and Sallustius were developed by the neoplatonists and revived by Renaissance mythographers as in the Theologia mythologica(1532). Nineteenth-century comparative mythology reinterpreted myth as evolution toward science (E. B. Tylor ), "disease of language" (Max Mller), or misinterpretation of magical ritual ( James Frazer). Later interpretations rejected opposition between myth and science, such as Jungianarchetypes, Joseph Campbell's "metaphor of spiritual potentiality", or Lvi-Strauss's fixed mental architecture. Tension between Campbell's comparative search for monomyth or Ur-myth and anthropological mythologists' skepticism of universal origin has marked the 20th century. Further, modern mythopoeia such as fantasy novels, manga, and urban legend, with many competing artificial mythoi acknowledged as fiction, supports the idea of myth as ongoing social practice. PUG Challenge Americas 2014

7 Dictinary.com definition of Mythology A traditional story, esp. one concerning the early history of a people or explaining some natural or social phenomenon, and typically involving supernatural beings or events A widely held but false belief or idea PUG Challenge Americas 2014

8 Wikipedia definition of Folklore Folklore (or lore) consists of legends, music, oral history, proverbs, jokes, popular beliefs, fairy tales, stories, tall tales, and customs included in the traditions of a culture, subculture, or group. It also includes the set of practices through which those expressive genres are shared. The study of folklore is sometimes called folkloristics, and people who study folklore are sometimes referred to as "folklorists". The English antiquarian William Thomsintroduced the word "folklore" in a letter published in the London journal The Athenaeum in 1846.[1] In usage, there is a continuum between folklore and mythology. Stith Thompson (1885-1976) made a major attempt to index the motifs of both folklore and mythology, providing an

outline for classifying new motifs, and within which scholars can keep track of all older motifs. PUG Challenge Americas 2014 9 Dictionary.com definition of Folklore The traditional beliefs, customs, and stories of a community, passed through the generations by word of mouth. Synonyms: mythology, lore, oral history, tradition,

folk tradition; More A body of popular myth and beliefs relating to a particular place, activity, or group of people. PUG Challenge Americas 2014 10 Warning To keep things interesting, Ive embedded some half truths among the falsehoods PUG Challenge Americas 2014

11 Database Storage & Configuration Databases using Type 2 Storage Areas dont need to be Dumped & Loaded A Records Per Block (RPB) of 1 is good for Index Areas A Data Cluster Size of 8 is good for Index Areas Always use a 4k DB block size if the File System block size is 4k (Windows NTFS, AIX, Linux)

Table Partitioning (V11.4) will improve performance PUG Challenge Americas 2014 12 Storage Progress doesnt work well with RAID 5 Only Progress?? RAID 5 will perform well if there is enough cache

How much is enough? Cache is still finite SAN Cache is expensive when it comes from companies like EMC (disclaimer, I own stock in EMC) Large SAN Caches and File System caches are good enough, no need for a large Buffer Cache (-B) PUG Challenge Americas 2014 13 Storage RAID Levels

If RAID 10 is better than RAID 5, then RAID 6 must also be better than RAID 5 RAID DP is even better because it doesnt use numbers DP = Double Parity RAID 50 is 10X better than RAID 5 RAID 50 is 5X better than RAID 10 PUG Challenge Americas 2014

14 Contrary Myths Classic: Must use Fixed size extents because of the overhead of growing a variable extent Modern: There is no need to use Fixed size extents any more because Storage is much faster than the old days PUG Challenge Americas 2014 15

Database Tuning Must truncate the BI for good performance Must truncate the BI file daily -spin Formula: 10000 * # of CPUs Set -B to 10% of DB Size One Async Page Writer (APW) per DB disk + 1 Came from the era when Sequent and DG still existed Ever heard of them?

AI Buffers (-aiabufs) = BI Buffers (-bibufs) * 1.5 Embedded in the Progress Documentation May have been started by Gus PUG Challenge Americas 2014 16 Database Tuning -directio only works on Data General or Sequent Was true in V6 & V7

-directio is no longer required V9.1E and V10/V11: fdatasync PUG Challenge Americas 2014 17 DB Administration An index rebuild is just as good as a full dump & load for improving performance

PUG Challenge Americas 2014 18 DB Administration You can use -F to force in to a database and then idxbuild will make it all better (i.e. reset the tainted flag) -F is evil PUG Challenge Americas 2014

19 DB Administration -F is evil On proutil truncate bi Agree (but might not have any option) On proshut Agree On promon Disagree PUG Challenge Americas 2014 20

DB Administration Its possible to re-org data online with proutil tablemove PUG Challenge Americas 2014 21 DB Administration Its possible to re-org data online with proutil tablemove

A table move is performed as a single transaction (BI Size) Since its a transaction, the AI files are updatedwith the entire table The Table is locked for the duration of the move Accessing the table with NO-LOCK during the move will produce wacky results PUG Challenge Americas 2014 22 Metrics & Measurements

A Buffer Hit % of 99% is Excellent If Im finding data in memory rather than going to the DB on disk all is well PUG Challenge Americas 2014 23 Progress Scalability More CPUs/Cores = Better Performance Progress cant handle large databases Going from 32-bit Progress to 64-bit Progress will

make things twice as fast PUG Challenge Americas 2014 24 Controversial Workgroup database is still a viable product With every contemporary server being multi-core All of the wish list items from various Information

Exchanges will be added to the product Remote Clients are much slower than Self-Service Clients PUG Challenge Americas 2014 25 4GL The primary function of the RELEASE statement is to release record locks The Mandatory attribute in the Data Dictionary specifies whether data is optional or not

PUG Challenge Americas 2014 26 4GL Development Methodology Progress builds or recommends the best tools & methodologies for building applications:

FastTrack Shell methodology ADM1 ADM2 AppBuilder Results Report Builder Rollbase Ad infinitum And probably some Ive missed

PUG Challenge Americas 2014 27 Historical Myths Microsoft was going to purchase Progress Software (in the 90s) PUG Challenge Americas 2014 28 Trivia

Source of the Database Epoch Date (Day 0) The Epoch Date serves as a reference point from which time is measured May 2, 1950 Day 0 in the 4GL 4714BC PUG Challenge Americas 2014 29 The 5 Minute Rule (for DB Conversion)

Where did that rule come from? New Index Manager in V7 The old index manager was removed Gus says that was a mistake Why? It meant that converting from a V6 DB to V7 required the indexes to be built in the new format.very time consuming in some cases

PUG Challenge Americas 2014 30 When/Why were multiple extents added EWC Electronics had the largest single volume Progress DB at the time and it was approaching 2GB V4 The same company subsequently hit :

A bug related to 2gb size A bug related to 4gb (limit of unsigned 32 bits) PUG Challenge Americas 2014 31 Famous Quotes Youre too stupid to be using our product Clyde Kessel, Data Language Corporation (DLC) & Progress Founding member in a conversation with a customer

Unix is snake oil Ken Olsen, CEO of DEC (when DEC still existed) PUG Challenge Americas 2014 32 Progress Software The half life of a Progress Marketing VP seems to be less than a year PUG Challenge Americas 2014 33

Conclusion Does anyone have any Myths they would like debunked or confirmed? PUG Challenge Americas 2014 34 Thank You! Questions? PUG Challenge Americas 2014

Recently Viewed Presentations

  • LO - To understand how Queen Elizabeth the First's reign ...

    LO - To understand how Queen Elizabeth the First's reign ...

    Arial Book Antiqua Default Design Learning Objectives To understand reasons why people explore the world To know how maps changed over time To recognise reasons why Tudor exploration increased during the reign of Elizabeth I Why do people explore the...
  • Formal Syntax and Language Change

    Formal Syntax and Language Change

    Language change: why study it? Elly van Gelderen Festival delle Scienze, Rome, May 2017 Insight into the mind of the learner Like She forgot all about the library like she told her old man now (Beach Boys' song). (2) So...
  • Liberalism as Systematic Theory

    Liberalism as Systematic Theory

    Argues that there can be a liberal theory that is fundamental, should be taken as existing prior to realism or institutionalism (i.e., must consult it first, then turn to others to explain unexplained variation rather than vice-versa) and which is...
  • Machine Learning Lecture 4

    Machine Learning Lecture 4

    A few things.. If you haven't starting using GPU server, please do it now! Kaggle competition ends in less than 1 month, please start it right now
  • IT Strategic Sourcing

    IT Strategic Sourcing

    OECD MEI and other OECD data Potential use to replace existing csv file processing. Possibility to leverage Eurostat's SODI-related data Content-Oriented Guidelines The IMF was an important contributor to the March 2006 draft version of the SDMX Content-Oriented Guidelines (COG).
  • Pensions Reform An update on the GB Wealth

    Pensions Reform An update on the GB Wealth

    An update on the GB Wealth and Assets Survey June 2007 Angela Donkin Cross-cutting Pensions Analysis Division Department for Work and Pensions
  • Payroll Cycle - staff.washington.edu

    Payroll Cycle - staff.washington.edu

    What are the basic business activities and data processing operations that are performed in the human resources management (HRM)/payroll cycle? What decisions need to be made in this cycle, and what information is needed to make these decisions? What are...
  • Development of STRATEGIC PLAN through 2010 1 DEVELOPMENT

    Development of STRATEGIC PLAN through 2010 1 DEVELOPMENT

    Focus Groups of Community Representatives & Board . Held on February 4th & 5th at Region XVI Service Center. 113 invitations sent to CEOs, Board and other comm. Reps.