How Large Can a File Really Be? And Other Maximum Capacities | System iNetwork:
A blog about IBM i (AS/400), MQ and other things developers or Admins need to know.
星期四, 11月 03, 2011
星期二, 10月 11, 2011
星期三, 5月 18, 2011
星期六, 5月 14, 2011
星期三, 4月 27, 2011
Use Ops Navigator to determine if the system is advising new access paths
You can use Ops Navigator to determine if the system is advising new access paths, look for combinations of high costs and frequency. This little SQL can show those suggested since last IPL
Code:
Code:
SELECT DBNAME as Library,
SYS_TNAME as File,
decimal(timesadv,6) as Advised,
date(lastadv) as Last_Adv,time(lastadv) as Time_Adv,
decimal(querycost,6) as Cost,
decimal(queryest,6) as Avg_Cost,
decimal(mticreated,6) as MTI_Create,
date(lastmtiuse) as MTI_LastUsed,
substr(KEYSADV,1,40) as Keys_Advised,
substr(leadkeys,1,40) as Key_Order
FROM qsys2/sysixadv
where mticreated > 0
ORDER BY queryest DESC
星期五, 4月 22, 2011
星期四, 4月 07, 2011
What's New in RPG for V6R1
May 2009
What’s New in RPG for V6R1
Barbara Morris, the lead developer for the WDS compilers in the IBM Toronto Lab
What’s New in RPG for V6R1
Barbara Morris, the lead developer for the WDS compilers in the IBM Toronto Lab
星期三, 3月 09, 2011
星期六, 3月 05, 2011
星期五, 3月 04, 2011
星期一, 2月 14, 2011
Threading in C# - Free E-book
Threading in C# - Free E-book
Part 1 Getting Started
Part 2 Basic Synchronization
Part 3 Using Threads
Part 4 Advanced Threading
Part 5 Parallel Programming
Part 1 Getting Started
Part 2 Basic Synchronization
Part 3 Using Threads
Part 4 Advanced Threading
Part 5 Parallel Programming
訂閱:
文章 (Atom)