Re: People Soft and There Tables
In article <6jfdui$6tp$1@news.xmission.com>, "KENDRICKS CHERYL" <KENDRICKS_CHERYL@heb.com> wrote: > > > I'm posting this again, since I have not received any replies. Come on > People Soft Informix Administrators, could try answering any/all of these > questions PLEASE? > ---------------------- Forwarded by KENDRICKS CHERYL/HEB45 on 05/14/98 > 01:01 PM --------------------------- > > From: KENDRICKS CHERYL on 05/07/98 11:46 AM > > To: informix-list@iiug.org > cc: pgcz@heb.com > Subject: People Soft and There Tables > > This question is address to all Informix DBAs who have People Soft Human > Resources and/or Financial We are installing 7.0 of this software on > Informix 7.23 and me and my partners would like to know: > > 1. What have you noticed as being the highly volatile tables? > > 2. How have you set up your user's in perspective of DBA responsibility > and those > that are development? In our shop DBAs are responsible for the > creation of DB > objects. But with People Tools the "sysadm" ID can do this > responsible, is this > person a DBA? > > 3. People Soft Tables also default in extent sizing (8 for 2K pages > system/16 for 4K > systems) do you have an idea of the large non-applications (highly > fragmented > tables) that you been noticing on your database? > > TIA, > Cheryl L. Kendricks > Sr. DBA HEB Grocery Co. > San Antonio, Texas > ---- Full Text based message can be sent to pgcz@heb.com ----- > > We have PeopleSoft Financials 6.x (G/L and AP modules) running on Informix Dynamic Server 7.2x. Hope this helps... 1. What have you noticed as being the highly volatile tables? *ps_jrnl_ln* (G/L module) ps_ledger (G/L module) 2. How have you set up your user's in perspective of DBA responsibility and those that are development? In our shop DBAs are responsible for the creation of DB objects. But with People Tools the "sysadm" ID can do this responsible, is this person a DBA? Despite this security loophole in PeopSoft, we DBAs still handle the creation of all database objects. The fact that the developers can do this is a potentential disaster, but we are keeping our fingers crossed. 3. People Soft Tables also default in extent sizing (8 for 2K pages system/16 for 4K systems) do you have an idea of the large non-applications (highly fragmented tables) that you been noticing on your database? This is a big one! We've been in production now for 4 months, and the following tables have become *badly* fragmented, some with as many as 118 extents! In fact, I'm doing a table reorg this weekend. ps_jrnl_ln ps_paymnt_tbl ps_distrib_line ps_ledger ps_jrnl_header ps_ledger_budg ps_voucher ps_voucher_line - Tim Payne, Informix DBA (ttpayne@tuc.com) -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading