gerd_renz3
VIP Member
Hi List,
I recently learned my first CNC-steps on the AS400 and came across a very strange behavior during full package buildS. When I examined the BuildError.txt file I found that counting the number of records in spec tables is very fast, except for fdatext, rdatext and potext. What I mean is this:
9/1/2003 20:21:08 0 Spec file FDATEXT begun.
9/1/2003 20:39:34 0 RDB record count in FDATEXT : 208479
(18:26 minutes)
9/2/2003 00:12:32 0 Spec file POTEXT begun.
9/2/2003 00:13:04 0 RDB record count in POTEXT : 47383
(0:32 minutes)
9/2/2003 00:34:53 0 Spec file RDATEXT begun.
9/2/2003 00:56:04 0 RDB record count in RDATEXT : 234611
(21:07 minutes)
whereas
9/1/2003 21:14:29 0 Spec file GBRSPEC begun.
9/1/2003 21:14:30 0 RDB record count in GBRSPEC : 2960514
(00:01 minutes)
All other counts are as fast as lightning. I have compared with 2 other AS400 installations, different AS versions, different OW versions. The behavior is always the same. I then compared with a Windows/Oracle installation and found that the record counting is not quite as fast, still taking only seconds each, and the time spent is somehow proportional to the number of records, which makes sense. When I do select count() via SQL on the AS or even via ODBC it´s always fast.
My question to all AS400 CNC gurus out there: what is so different with these tables, fdatext/F98750, rdatext/F98760, potext/F98306 that the record counting would take this much time? If you add it up, it´s over half an hour delay just for that. Can others confirm this or am I seeing ghosts ?
Thanks for reading the above, Gerd
ERP8, SP22, Update1, AS400 V5R2
I recently learned my first CNC-steps on the AS400 and came across a very strange behavior during full package buildS. When I examined the BuildError.txt file I found that counting the number of records in spec tables is very fast, except for fdatext, rdatext and potext. What I mean is this:
9/1/2003 20:21:08 0 Spec file FDATEXT begun.
9/1/2003 20:39:34 0 RDB record count in FDATEXT : 208479
(18:26 minutes)
9/2/2003 00:12:32 0 Spec file POTEXT begun.
9/2/2003 00:13:04 0 RDB record count in POTEXT : 47383
(0:32 minutes)
9/2/2003 00:34:53 0 Spec file RDATEXT begun.
9/2/2003 00:56:04 0 RDB record count in RDATEXT : 234611
(21:07 minutes)
whereas
9/1/2003 21:14:29 0 Spec file GBRSPEC begun.
9/1/2003 21:14:30 0 RDB record count in GBRSPEC : 2960514
(00:01 minutes)
All other counts are as fast as lightning. I have compared with 2 other AS400 installations, different AS versions, different OW versions. The behavior is always the same. I then compared with a Windows/Oracle installation and found that the record counting is not quite as fast, still taking only seconds each, and the time spent is somehow proportional to the number of records, which makes sense. When I do select count() via SQL on the AS or even via ODBC it´s always fast.
My question to all AS400 CNC gurus out there: what is so different with these tables, fdatext/F98750, rdatext/F98760, potext/F98306 that the record counting would take this much time? If you add it up, it´s over half an hour delay just for that. Can others confirm this or am I seeing ghosts ?
Thanks for reading the above, Gerd
ERP8, SP22, Update1, AS400 V5R2