Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Mobilink

6 posts in General Discussion Last posting was on 2007-10-12 16:42:22.0Z
Herman Posted on 2007-10-11 09:29:17.0Z
Sender: 2599.470deb4a.1804289383@sybase.com
From: Herman
Newsgroups: ianywhere.public.general
Subject: Mobilink
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470deced.25b0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Oct 2007 02:29:17 -0700
X-Trace: forums-1-dub 1192094957 10.22.241.41 (11 Oct 2007 02:29:17 -0700)
X-Original-Trace: 11 Oct 2007 02:29:17 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6396
Article PK: 4735

I have SQL Remote setup to upload data to a consolidated
database.
I also have Mobilink setup to upload data to a different
consolidated database.

Both methods upload the exact same tables and columns. Based
on the number of rows in the tables, the Mobilink
consolidated database contains less rows in total then the
SQL Remote consolidated database. Both have a page size of
8192, however the actual database size seems to be
considerably larger. SQL Remote db size alittle over 3gb and
Mobilink alittle over 10gb. I compared rows in tables,
columns in tables, indexes, foreign keys, how else can I
determine what is causing this database to be so much larger
or is their something in Mobilink that causes this?


Chris Keating (Sybase iAnywhere) Posted on 2007-10-11 12:26:59.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink
References: <470deced.25b0.1681692777@sybase.com>
In-Reply-To: <470deced.25b0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <470e1693$1@forums-1-dub>
Date: 11 Oct 2007 05:26:59 -0700
X-Trace: forums-1-dub 1192105619 10.25.98.110 (11 Oct 2007 05:26:59 -0700)
X-Original-Trace: 11 Oct 2007 05:26:59 -0700, keating-d620.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6398
Article PK: 2872

Is this size determined after the database has been stopped i.e., the
checkpoint log cleaned up?

What is the output of dbinfo with the -u option for both databases?

i.e.,
dbinfo -c "<conn_str_mobilink_db>" -u -o Mobilink.txt
dbinfo -c "<conn_str_sqlremote_db>" -u -o SqlRemote.txt

Herman wrote:
> I have SQL Remote setup to upload data to a consolidated
> database.
> I also have Mobilink setup to upload data to a different
> consolidated database.
>
> Both methods upload the exact same tables and columns. Based
> on the number of rows in the tables, the Mobilink
> consolidated database contains less rows in total then the
> SQL Remote consolidated database. Both have a page size of
> 8192, however the actual database size seems to be
> considerably larger. SQL Remote db size alittle over 3gb and
> Mobilink alittle over 10gb. I compared rows in tables,
> columns in tables, indexes, foreign keys, how else can I
> determine what is causing this database to be so much larger
> or is their something in Mobilink that causes this?


Herman Miller Posted on 2007-10-11 14:14:15.0Z
Sender: 2599.470deb4a.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470e2fb7.2b39.1681692777@sybase.com>
References: <470e1693$1@forums-1-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub470e2fb7"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Oct 2007 07:14:15 -0700
X-Trace: forums-1-dub 1192112055 10.22.241.41 (11 Oct 2007 07:14:15 -0700)
X-Original-Trace: 11 Oct 2007 07:14:15 -0700, 10.22.241.41
Lines: 1423
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6401
Article PK: 2876

See attachments. Let me know.

> Is this size determined after the database has been
> stopped i.e., the checkpoint log cleaned up?
>
> What is the output of dbinfo with the -u option for both
> databases?
>
> i.e.,
> dbinfo -c "<conn_str_mobilink_db>" -u -o Mobilink.txt
> dbinfo -c "<conn_str_sqlremote_db>" -u -o SqlRemote.txt
>
>
>
> Herman wrote:
> > I have SQL Remote setup to upload data to a consolidated
> > database.
> > I also have Mobilink setup to upload data to a different
> > consolidated database.
> >
> > Both methods upload the exact same tables and columns.
> > Based on the number of rows in the tables, the Mobilink
> > consolidated database contains less rows in total then
> > the SQL Remote consolidated database. Both have a page
> > size of 8192, however the actual database size seems to
> > be considerably larger. SQL Remote db size alittle over
> > 3gb and Mobilink alittle over 10gb. I compared rows in
> > tables, columns in tables, indexes, foreign keys, how
> > else can I determine what is causing this database to be
> > so much larger or is their something in Mobilink that
> causes this?

Adaptive Server Anywhere Information Utility Version 9.0.2.3534
Not allowed while 'MainuddinS' is using the database
Database : D:\LCOS_Consolidated\LCOS_Consolidated.db
Log file : D:\LCOS_Consolidated\LCOS_Consolidated.log
Log mirror: none
Free pages: unable to determine
Compressed: No
Page size : 8192
Encrypted : No
Strings padded with blanks for comparisons: No
Respect letter-case when comparing: No ('A' equal to 'a')
Collation sequence: 1252LATIN1 (Code Page 1252, Windows Latin 1, Western)
Java classes installed: No
Database checksums enabled: No


Table Table Index Percent Name
id Pages %used Pages %used of File
----- -------- ----- -------- ----- ------- ----
======== ========
Total: 0 table + 0 index + -1 free + 0 other = 1 pages
Adaptive Server Anywhere Information Utility Version 9.0.2.3534
Specified database not found
Adaptive Server Anywhere Information Utility Version 9.0.2.3534
Specified database not found
Adaptive Server Anywhere Information Utility Version 9.0.2.3534
Database : D:\LCOS_Consolidated\LCOS_Consolidated.db
Log file : D:\LCOS_Consolidated\LCOS_Consolidated.log
Log mirror: none
Free pages: 70639
Compressed: No
Page size : 8192
Encrypted : No
Strings padded with blanks for comparisons: No
Respect letter-case when comparing: No ('A' equal to 'a')
Collation sequence: 1252LATIN1 (Code Page 1252, Windows Latin 1, Western)
Java classes installed: No
Database checksums enabled: No


Table Table Index Percent Name
id Pages %used Pages %used of File
----- -------- ----- -------- ----- ------- ----
1 13 ( 85) 7 ( 48) 0 SYSTABLE
2 34 ( 97) 40 ( 70) 0 SYSCOLUMN
3 1 ( 57) 4 ( 14) 0 SYSINDEX
4 1 ( 36) 3 ( 29) 0 SYSIXCOL
5 2 ( 65) 4 ( 40) 0 SYSFOREIGNKEY
6 2 ( 36) 3 ( 65) 0 SYSFKCOL
7 1 ( 0) 2 ( 0) 0 SYSFILE
8 1 ( 6) 1 ( 3) 0 SYSDOMAIN
9 2 ( 50) 2 ( 23) 0 SYSUSERPERM
10 3 ( 74) 7 ( 53) 0 SYSTABLEPERM
11 1 ( 5) 4 ( 3) 0 SYSCOLPERM
12 1 ( 69) 2 ( 30) 0 SYSOPTION
13 1 ( 20) 3 ( 21) 0 SYSGROUP
14 2 ( 8) 1 ( 0) 0 SYSCOLLATION
15 526 ( 96) 15 ( 44) 0 SYSPROCEDURE
16 42 ( 97) 45 ( 80) 0 SYSPROCPARM
17 11 ( 83) 6 ( 36) 0 SYSTRIGGER
18 4 ( 32) 7 ( 56) 0 SYSPROCPERM
19 1 ( 1) 3 ( 0) 0 SYSPUBLICATION
20 1 ( 26) 3 ( 13) 0 SYSARTICLE
21 1 ( 0) 3 ( 0) 0 SYSARTICLECOL
22 1 ( 42) 5 ( 5) 0 SYSREMOTEUSER
23 1 ( 11) 3 ( 6) 0 SYSSUBSCRIPTION
24 1 ( 0) 1 ( 0) 0 SYSUSERMESSAGES
25 1 ( 4) 5 ( 1) 0 SYSUSERTYPE
26 1 ( 0) 2 ( 0) 0 SYSEXTENT
27 1 ( 1) 2 ( 1) 0 SYSREMOTETYPE
28 1 ( 9) 1 ( 4) 0 SYSSQLSERVERTYPE
29 1 ( 5) 1 ( 5) 0 SYSTYPEMAP
30 1 ( 0) 2 ( 0) 0 SYSLOGIN
31 1 ( 0) 2 ( 0) 0 SYSJAR
32 1 ( 0) 5 ( 0) 0 SYSJAVACLASS
33 1 ( 0) 2 ( 0) 0 SYSJARCOMPONENT
34 1 ( 1) 1 ( 0) 0 SYSCOLLATIONMAPPINGS
35 1 ( 0) 1 ( 0) 0 SYSSERVERS
36 1 ( 0) 3 ( 0) 0 SYSEXTERNLOGINS
45 1 ( 0) 3 ( 0) 0 SYSCAPABILITY
46 1 ( 54) 1 ( 36) 0 SYSCAPABILITYNAME
47 1 ( 2) 2 ( 1) 0 SYSREMOTEOPTIONTYPE
48 1 ( 2) 2 ( 1) 0 SYSREMOTEOPTION
49 1 ( 0) 5 ( 0) 0 SYSSYNC
50 1 ( 7) 2 ( 2) 0 SYSEVENTTYPE
51 2 ( 2) 4 ( 0) 0 SYSEVENT
52 1 ( 0) 2 ( 0) 0 SYSSCHEDULE
53 1 ( 0) 1 ( 0) 0 SYSOPTREQUEST
54 1 ( 0) 2 ( 0) 0 SYSOPTREWRITE
55 1 ( 0) 2 ( 0) 0 SYSOPTBLOCK
56 1 ( 0) 2 ( 0) 0 SYSOPTJOINSTRATEGY
57 1 ( 0) 2 ( 0) 0 SYSOPTQUANTIFIER
58 1 ( 0) 4 ( 0) 0 SYSOPTORDER
59 154 ( 89) 22 ( 57) 0 SYSCOLSTAT
60 1 ( 0) 1 ( 0) 0 SYSOPTSTAT
61 1 ( 2) 1 ( 1) 0 SYSATTRIBUTENAME
62 4 ( 56) 4 ( 60) 0 SYSATTRIBUTE
63 1 ( 0) 2 ( 0) 0 SYSWEBSERVICE
64 1 ( 4) 1 ( 1) 0 SYSHISTORY
65 2 ( 75) 8 ( 60) 0 SYSCONSTRAINT
66 1 ( 2) 2 ( 0) 0 SYSCHECK
335 1 ( 0) 0 ( 0) 0 DUMMY
336 1 ( 0) 0 ( 0) 0 SYSINFO
337 1 ( 28) 1 ( 34) 0 RowGenerator
376 1 ( 0) 1 ( 0) 0 rs_lastcommit
377 1 ( 0) 1 ( 0) 0 rs_threads
379 1 ( 0) 1 ( 0) 0 ul_file
380 1 ( 0) 3 ( 0) 0 ul_statement
381 1 ( 0) 2 ( 0) 0 ul_variable
384 1 ( 0) 2 ( 0) 0 ml_user
385 1 ( 0) 2 ( 0) 0 ml_subscription
386 1 ( 0) 2 ( 0) 0 ml_table
387 1 ( 0) 1 ( 0) 0 ml_script
388 1 ( 0) 2 ( 0) 0 ml_script_version
389 1 ( 0) 3 ( 0) 0 ml_connection_script
390 1 ( 0) 4 ( 0) 0 ml_table_script
391 1 ( 16) 1 ( 3) 0 ml_property
392 1 ( 0) 1 ( 0) 0 ml_scripts_modified
395 1 ( 0) 1 ( 0) 0 ml_device
396 1 ( 0) 2 ( 0) 0 ml_device_address
397 1 ( 0) 2 ( 0) 0 ml_listening
398 1 ( 0) 1 ( 0) 0 ml_qa_notifications
399 1 ( 0) 1 ( 0) 0 ml_qa_repository
400 1 ( 0) 1 ( 0) 0 ml_qa_status_history
401 1 ( 0) 1 ( 0) 0 ml_qa_repository_staging
402 1 ( 0) 1 ( 0) 0 ml_qa_status_staging
403 1 ( 0) 2 ( 0) 0 ml_qa_delivery
404 1 ( 0) 2 ( 0) 0 ml_qa_repository_props
406 1 ( 0) 1 ( 0) 0 ml_qa_global_props
407 2 ( 72) 1 ( 52) 0 EXCLUDEOBJECT
408 1 ( 0) 1 ( 0) 0 migrate_remote_table_list
409 1 ( 0) 1 ( 0) 0 migrate_sql_defn
410 1 ( 0) 1 ( 0) 0 migrate_remote_fks_list
411 1 ( 0) 1 ( 0) 0 ix_consultant_master
412 1 ( 14) 2 ( 10) 0 ix_consultant_query_text
413 1 ( 10) 2 ( 4) 0 ix_consultant_query_phase
414 13 ( 86) 2 ( 36) 0 ix_consultant_workload
415 1 ( 12) 2 ( 3) 0 ix_consultant_query_index
416 1 ( 13) 2 ( 2) 0 ix_consultant_index
417 1 ( 14) 2 ( 5) 0 ix_consultant_ixcol
418 1 ( 0) 2 ( 0) 0 ix_consultant_affected_columns
419 1 ( 80) 2 ( 13) 0 ix_consultant_log
420 1 ( 0) 1 ( 0) 0 ix_consultant_capture
424 1 ( 4) 1 ( 1) 0 pbcattbl
425 1 ( 2) 1 ( 1) 0 pbcatcol
426 1 ( 0) 1 ( 0) 0 pbcatfmt
427 1 ( 0) 1 ( 0) 0 pbcatvld
428 1 ( 0) 1 ( 0) 0 pbcatedt
429 16 ( 43) 2 ( 59) 0 ctr_courses
430 35 ( 77) 10 ( 42) 0 clt_courses
431 1515 ( 97) 788 ( 71) 0 clt_actanswers
432 24 ( 61) 10 ( 41) 0 clt_actscores
433 24299 ( 97) 13309 ( 73) 9 clt_satanswers
434 1617 ( 96) 963 ( 73) 0 clt_satgridanswers
435 403 ( 96) 156 ( 68) 0 clt_satscores
436 1 ( 0) 1 ( 0) 0 hmis_param
437 693 ( 96) 559 ( 65) 0 clt_billingparties
438 428 ( 95) 157 ( 58) 0 clt_creditcards
439 1 ( 12) 1 ( 5) 0 sys_user_report
440 1 ( 0) 0 ( 0) 0 hmis_user
441 2 ( 79) 2 ( 20) 0 ctr_discount
442 669 ( 96) 113 ( 53) 0 clt_testdata
443 1 ( 0) 2 ( 0) 0 clt_courses_chg
444 1 ( 0) 1 ( 0) 0 Messages
445 1551 ( 83) 712 ( 74) 0 clt_clients
446 13025 ( 96) 6103 ( 69) 4 clt_scheduling
447 4250 ( 97) 3429 ( 62) 1 clt_phones
448 4422 ( 96) 1942 ( 54) 1 clt_status
449 8333 ( 97) 2374 ( 58) 2 clt_addresses
450 70392 ( 97) 96673 ( 70) 42 clt_charges
451 4033 ( 96) 1397 ( 67) 1 clt_interimconference
452 4565 ( 97) 1234 ( 69) 1 clt_inq_cch
453 1 ( 1) 2 ( 0) 0 clt_testselection
454 6 ( 72) 2 ( 10) 0 ctr_preferences
455 1 ( 0) 2 ( 0) 0 clt_satanalysis_results
456 9602 ( 97) 4698 ( 65) 3 clt_hmpe
457 32 ( 90) 25 ( 67) 0 sys_answerkey
458 1 ( 28) 1 ( 12) 0 sys_attendcodes
459 2 ( 48) 1 ( 46) 0 sys_hmpe_sets
460 1 ( 18) 1 ( 8) 0 sys_iota
461 1 ( 8) 1 ( 2) 0 sys_irirate
462 1 ( 0) 1 ( 0) 0 sys_level
463 1 ( 29) 1 ( 5) 0 sys_levels
464 4 ( 92) 2 ( 36) 0 sys_math_curriculum
465 1 ( 10) 1 ( 2) 0 sys_math_placementexam
466 1 ( 19) 1 ( 4) 0 sys_math_publisher
467 2 ( 59) 1 ( 23) 0 sys_math_skills
468 4 ( 96) 3 ( 52) 0 sys_math_subskill
469 1 ( 0) 1 ( 0) 0 sys_math_version
470 1 ( 8) 1 ( 2) 0 sys_mathph
471 3 ( 79) 1 ( 27) 0 sys_phonics_curriculum
472 1 ( 39) 1 ( 7) 0 sys_phonics_skills
473 1 ( 0) 1 ( 0) 0 sys_phonics_phonics
474 1 ( 7) 1 ( 2) 0 sys_phonics_phonicspe
475 1 ( 22) 1 ( 4) 0 sys_phonics_publish
476 1 ( 88) 1 ( 49) 0 sys_phonics_subskill
477 2 ( 52) 1 ( 12) 0 sys_vendors
478 1 ( 44) 1 ( 6) 0 sys_report_dwobject_procs
479 2 ( 65) 1 ( 37) 0 sys_reports
480 1 ( 73) 2 ( 30) 0 sys_rprt_log
481 40 ( 90) 8 ( 78) 0 sys_sat_description
482 24 ( 94) 6 ( 61) 0 sys_sat_conversion
483 4 ( 74) 1 ( 49) 0 sys_sat_psat_act_codes
484 3 ( 67) 2 ( 45) 0 sys_satgridanswers
485 4 ( 27) 3 ( 53) 0 sys_sequance
486 3 ( 69) 1 ( 33) 0 sys_sdct
487 1 ( 40) 1 ( 14) 0 sys_sortr
488 1 ( 41) 0 ( 0) 0 sys_sshat
489 1 ( 41) 1 ( 3) 0 sys_sshahug
490 1 ( 41) 1 ( 3) 0 sys_sshahlg
491 1 ( 0) 2 ( 0) 0 clt_act_results
492 48 ( 91) 13 ( 81) 0 sys_act_row_to_scaled
493 1 ( 0) 2 ( 0) 0 clt_letters
494 1 ( 0) 2 ( 0) 0 ctr_letters
495 1 ( 39) 1 ( 2) 0 clt_actanalysis_results
496 1806 ( 96) 658 ( 63) 0 clt_changes
497 1 ( 72) 2 ( 20) 0 ctr_holidays
498 3956 ( 97) 1653 ( 68) 1 clt_payments
499 1 ( 0) 2 ( 0) 0 clt_payments_details
500 1629 ( 96) 663 ( 62) 0 clt_rates
501 1 ( 0) 1 ( 0) 0 ctr_billing_messages
502 5 ( 62) 2 ( 18) 0 clt_billing_messages
503 1 ( 0) 2 ( 0) 0 clt_discount
504 748 ( 96) 308 ( 62) 0 clt_finance
505 1 ( 0) 1 ( 0) 0 security_info
506 72 ( 86) 24 ( 74) 0 ctr_schools
507 1 ( 0) 2 ( 0) 0 ctr_schools_districts
508 1 ( 0) 2 ( 0) 0 ctr_schools_people
509 8 ( 90) 8 ( 52) 0 ctr_codes_referral
510 1 ( 11) 1 ( 1) 0 sys_schedule_templates
511 1 ( 5) 1 ( 1) 0 sys_codes_drop
512 1183 ( 97) 271 ( 63) 0 clt_initialconference
513 1 ( 0) 0 ( 0) 0 batch_user
514 1 ( 0) 0 ( 0) 0 batchdw
515 1 ( 0) 0 ( 0) 0 batchtim
516 1 ( 0) 1 ( 0) 0 batch_report
517 1 ( 0) 1 ( 0) 0 hmis_rprt_param_copy
518 1 ( 0) 1 ( 0) 0 hmis_rprt_param
519 1 ( 0) 2 ( 0) 0 clt_attend_summary
520 68 ( 90) 6 ( 46) 0 clt_behavior
521 1 ( 7) 1 ( 2) 0 sys_codes_appointments
522 1 ( 15) 1 ( 7) 0 sys_codes_belongsto
523 1 ( 2) 1 ( 1) 0 sys_codes_addresstype
524 1 ( 8) 1 ( 1) 0 sys_codes_phonetype
525 1 ( 1) 1 ( 0) 0 sys_codes_countries
526 1 ( 4) 1 ( 1) 0 sys_codes_salutation
527 1 ( 6) 1 ( 2) 0 sys_codes_statuscodes
528 1 ( 4) 1 ( 2) 0 sys_codes_grades
529 1 ( 6) 1 ( 1) 0 sys_codes_charges_trantype
530 1 ( 4) 1 ( 1) 0 sys_codes_attend
531 2 ( 69) 2 ( 48) 0 ctr_codes_inq_reason
532 59 ( 90) 36 ( 68) 0 clt_testbehavior
533 1 ( 7) 1 ( 1) 0 sys_ic_prep_reports
534 1 ( 0) 3 ( 0) 0 clt_ic_information
535 4 ( 90) 4 ( 40) 0 ctr_staff_position_code
536 1 ( 97) 2 ( 26) 0 ctr_staff_positions
537 67 ( 92) 34 ( 56) 0 ctr_staff
538 1 ( 22) 1 ( 5) 0 ctr_staff_events
539 7 ( 84) 6 ( 36) 0 ctr_phones
540 1 ( 8) 1 ( 2) 0 sys_codes_ininterest
541 4 ( 81) 2 ( 35) 0 ctr_addresses
542 1 ( 25) 1 ( 7) 0 sys_codes_states
543 1 ( 0) 2 ( 0) 0 ctr_staff_compensation
544 1 ( 0) 2 ( 0) 0 ctr_staff_payroll
545 3 ( 43) 3 ( 5) 0 ctr_central
546 1 ( 3) 1 ( 1) 0 sys_codes_contactby
547 40 ( 94) 14 ( 59) 0 ctr_school_addresses
548 56 ( 92) 26 ( 63) 0 ctr_school_phones
549 1 ( 0) 2 ( 0) 0 ctr_schools_events
550 1 ( 0) 2 ( 0) 0 ctr_schools_contacts
551 1 ( 8) 1 ( 1) 0 ctr_test_list
552 1 ( 1) 1 ( 0) 0 sys_codes_absences_not_used
553 1 ( 2) 1 ( 1) 0 sys_codes_inq_types
554 1 ( 4) 1 ( 2) 0 sys_writingsample
555 1 ( 1) 1 ( 1) 0 sys_codes_eventtype
556 1 ( 2) 1 ( 1) 0 sys_codes_maritalstatus
557 1 ( 1) 1 ( 1) 0 sys_codes_ethnicity
558 1 ( 9) 1 ( 5) 0 sys_grade_suffix
559 4 ( 77) 2 ( 69) 0 ctr_codes_occupations
560 1 ( 2) 1 ( 1) 0 sys_codes_apptstatus
561 1 ( 3) 1 ( 2) 0 sys_codes_charge_sources
562 1 ( 5) 1 ( 2) 0 sys_codes_paymenttype
563 1 ( 4) 1 ( 1) 0 sys_codes_paymethod
564 1 ( 6) 1 ( 2) 0 sys_ph_study_skills
565 1 ( 36) 1 ( 13) 0 sys_ph_writing
566 1 ( 6) 1 ( 2) 0 sys_phonics1
567 1 ( 2) 1 ( 1) 0 sys_ph_handwriting
568 1 ( 4) 1 ( 2) 0 sys_rosner
569 1 ( 10) 1 ( 2) 0 sys_ph_phonics
570 7 ( 89) 8 ( 42) 0 ctr_iri
571 1 ( 3) 1 ( 1) 0 sys_code_positionevent
572 1 ( 16) 2 ( 3) 0 ctr_attendance
573 1 ( 0) 1 ( 0) 0 security_apps
574 1 ( 1) 1 ( 0) 0 security_groupings
575 1 ( 6) 1 ( 1) 0 security_users
576 1 ( 0) 2 ( 0) 0 clt_hppe
577 1 ( 31) 1 ( 13) 0 sys_iri_by_month
578 1 ( 37) 1 ( 2) 0 sys_initial_conference_prep_form
579 1 ( 5) 1 ( 1) 0 sys_codes_form
580 4 ( 89) 3 ( 46) 0 sys_ph_svmpt
581 1 ( 2) 1 ( 0) 0 sys_rating_wold
582 574 ( 65) 203 ( 56) 0 clt_pres_hours
583 3 ( 89) 1 ( 61) 0 sys_ph_sort_voc_rdg
584 1 ( 0) 0 ( 0) 0 inq_vol
585 1 ( 2) 1 ( 0) 0 sys_grade_conv
586 1 ( 4) 1 ( 1) 0 sys_reading_readiness
587 1 ( 8) 1 ( 1) 0 sys_chall
588 1 ( 66) 1 ( 21) 0 sys_ph_iricomp_rdg_nonnum
589 1 ( 37) 0 ( 0) 0 sys_ph_miscues_voc
590 1 ( 6) 1 ( 2) 0 sys_ph_miscues_voc_nonnum
591 1 ( 6) 1 ( 2) 0 sys_ph_rate_rdg_nonnum
592 2 ( 88) 1 ( 57) 0 sys_ph_ach_voc_rdg
593 2 ( 55) 1 ( 31) 0 sys_ph_rate_rdg
594 2400 ( 97) 1021 ( 69) 0 clt_inquiryaction
595 1 ( 14) 1 ( 5) 0 sys_ph_sort_voc_rdg_nonnum
596 9 ( 86) 1 ( 7) 0 erd_center_information
597 1 ( 25) 1 ( 4) 0 erd_urgency_words
598 2 ( 21) 2 ( 2) 0 ctr_notes
599 95 ( 73) 5 ( 38) 0 clt_notes
600 1 ( 28) 2 ( 2) 0 ctr_staff_notes
601 1 ( 0) 1 ( 0) 0 erd_seq_numb
602 1 ( 5) 1 ( 1) 0 sys_rating_ach_test
603 1 ( 4) 1 ( 1) 0 sys_codes_disposition
604 32 ( 80) 19 ( 61) 0 ctr_fees
605 4 ( 76) 3 ( 67) 0 ctr_services
606 1 ( 3) 1 ( 1) 0 sys_codes_subconreason
607 1 ( 25) 1 ( 3) 0 sys_codes_sat_testcodes
608 1 ( 13) 1 ( 1) 0 sys_codes_act_testcodes
609 7 ( 86) 3 ( 47) 0 erd_towns
610 1 ( 72) 1 ( 18) 0 sys_dt_achtest_norms_default
611 1 ( 0) 1 ( 0) 0 inq_newclientid
612 3 ( 66) 2 ( 18) 0 ctr_monthly_exp
613 1 ( 5) 1 ( 1) 0 sys_pres_hrs_minmax
614 276 ( 73) 119 ( 72) 0 ctr_owns_component
615 1 ( 0) 2 ( 0) 0 ul_user
616 1 ( 0) 2 ( 0) 0 ul_table
617 1 ( 0) 1 ( 0) 0 ul_script
618 1 ( 0) 2 ( 0) 0 ul_connection_script
619 1 ( 0) 3 ( 0) 0 ul_table_script
620 1 ( 0) 1 ( 0) 0 ul_scripts_modified
621 417 ( 69) 320 ( 71) 0 ctr_own_master
622 1 ( 7) 1 ( 1) 0 sys_statements
623 1 ( 8) 1 ( 2) 0 sys_codes_services
624 56 ( 81) 2 ( 39) 0 sys_cur_master
625 1 ( 17) 1 ( 6) 0 sys_component_form
626 1 ( 4) 1 ( 1) 0 sys_cur_classifications
627 1 ( 0) 1 ( 0) 0 sys_cur_component_guidelines_skills
628 6 ( 90) 3 ( 65) 0 sys_cur_master_relates_to_school
629 48 ( 77) 10 ( 66) 0 sys_cur_component
630 4070 ( 96) 2347 ( 77) 1 clt_statement
631 1 ( 0) 1 ( 0) 0 SYS_Version
632 1 ( 2) 1 ( 1) 0 ctr_codes_creditcards
633 72 ( 89) 0 ( 0) 0 sys_math_newskill
634 1 ( 97) 1 ( 48) 0 sys_ph_sdct
635 1 ( 2) 1 ( 0) 0 pbcattbl
636 1 ( 2) 1 ( 1) 0 pbcatcol
637 1 ( 8) 1 ( 2) 0 pbcatfmt
638 1 ( 0) 1 ( 0) 0 pbcatvld
639 1 ( 12) 1 ( 2) 0 pbcatedt
640 1 ( 2) 1 ( 1) 0 sys_codes_discount
641 2534 ( 65) 954 ( 63) 0 clt_appointments
642 160 ( 94) 20 ( 93) 0 STF_Teachers
643 64 ( 93) 38 ( 90) 0 STF_PayCode
644 1082 ( 63) 1014 ( 42) 0 STF_HoursWorked
645 32 ( 70) 18 ( 77) 0 ctr_teacher_hours
646 1 ( 1) 1 ( 0) 0 SYS_ADI
647 1 ( 4) 2 ( 1) 0 SYS_ADISub
648 1 ( 15) 1 ( 5) 0 STF_OpsManagers
649 2269 ( 87) 281 ( 60) 0 clt_payments_audit
650 1 ( 13) 1 ( 5) 0 sys_ph_phonics_hours
651 1 ( 84) 1 ( 11) 0 sys_reports_batch
652 24 ( 73) 6 ( 68) 0 sys_ph_iricomp_rdg
653 1 ( 0) 1 ( 0) 0 sys_statement_details
654 3 ( 88) 3 ( 34) 0 sys_tier1_corereader_component
655 1 ( 30) 1 ( 14) 0 sys_tier1_vocab_component
656 930 ( 96) 414 ( 63) 0 clt_payment_allocation
657 2 ( 96) 1 ( 16) 0 security_template
658 1 ( 7) 1 ( 1) 0 Fran_Reports
659 2 ( 42) 2 ( 7) 0 Fran_Reports_Definitions
660 1 ( 0) 2 ( 0) 0 Fran_Reports_Activity
661 1 ( 80) 1 ( 17) 0 sys_iri_defaults
662 1 ( 17) 1 ( 8) 0 sys_tier1_vp
663 1 ( 20) 1 ( 10) 0 sys_tier1_phonics
664 1 ( 18) 1 ( 9) 0 sys_tier1_hw
665 1 ( 95) 1 ( 47) 0 sys_tier1_addreading
666 1 ( 42) 1 ( 8) 0 sys_tier1_corereader
667 1 ( 33) 1 ( 6) 0 sys_tier1_vocab
668 1 ( 2) 1 ( 1) 0 sys_rating_boehm
669 1 ( 5) 1 ( 1) 0 sys_codes_schoolposition
670 1 ( 14) 1 ( 4) 0 Sys_ACT_Master
671 16 ( 52) 6 ( 45) 0 Sys_ACT_Scaled_Score
673 1 ( 23) 1 ( 6) 0 Sys_SAT_Master
674 1 ( 87) 1 ( 12) 0 Sys_SAT_Question_Codes
675 20 ( 72) 29 ( 35) 0 Sys_SAT_Answers
676 5 ( 86) 2 ( 86) 0 Sys_SAT_Score_Conversion
677 6 ( 92) 2 ( 63) 0 Sys_SAT_Essay_Score_Conversion
678 56 ( 59) 34 ( 87) 0 Sys_ACT_Writing
679 1 ( 0) 1 ( 0) 0 clt_lea_invoices_payment
680 1 ( 53) 2 ( 5) 0 clt_lea_invoices
681 1 ( 0) 2 ( 0) 0 Ctr_Staff_Schedule
682 1 ( 0) 2 ( 0) 0 Ctr_Staff_Vacation
683 2 ( 0) 3 ( 0) 0 Ctr_Teacher_Schedule
684 2 ( 0) 2 ( 0) 0 Clt_Study_Profile
685 1 ( 20) 2 ( 3) 0 ctr_NCLB_Agencies
686 1 ( 0) 2 ( 0) 0 clt_deleted_charges
687 1 ( 0) 2 ( 0) 0 ctr_student_programs_templates
688 2 ( 0) 2 ( 0) 0 clt_conferenceattendees
689 1 ( 0) 1 ( 0) 0 ctr_emails
690 1 ( 0) 1 ( 0) 0 ctr_distribution_lists
691 1 ( 0) 3 ( 0) 0 ctr_emailsbylists
692 1 ( 0) 2 ( 0) 0 clt_InquiryImage
693 4 ( 78) 1 ( 53) 0 Sys_ACT_Question_Codes
694 56 ( 94) 61 ( 66) 0 Sys_ACT_Answers
695 16 ( 59) 6 ( 45) 0 Sys_ACT_Percent
696 1 ( 0) 2 ( 0) 0 Ctr_SalesTaxes
697 8 ( 86) 4 ( 39) 0 sys_writing_newskill
698 1 ( 6) 1 ( 3) 0 sys_writing_skill
699 1 ( 26) 1 ( 14) 0 sys_writing_subskill
700 1 ( 0) 2 ( 0) 0 clt_satprescribedhours
701 1 ( 0) 1 ( 0) 0 sys_defaults
702 1 ( 0) 3 ( 0) 0 ctr_defaults
703 1 ( 0) 3 ( 0) 0 Fran_Reports_Sent
704 1 ( 0) 1 ( 0) 0 Sys_PSAT_Master
705 1 ( 36) 1 ( 6) 0 Sys_PSAT_Question_Codes
706 1 ( 96) 5 ( 14) 0 Sys_PSAT_Answers
707 1 ( 31) 2 ( 6) 0 Sys_PSAT_Score_Conversion
708 1 ( 78) 2 ( 9) 0 Clt_PSAT_Score
709 46 ( 85) 23 ( 65) 0 Clt_PSAT_Answers
710 64 ( 87) 11 ( 82) 0 erd_stara_call_details
711 4 ( 75) 1 ( 62) 0 estara_temp
712 5 ( 43) 3 ( 25) 0 ctr_goals
713 2 ( 47) 1 ( 53) 0 temp_clientid
714 24 ( 81) 7 ( 66) 0 sys_phonics_newskill
715 1 ( 0) 1 ( 0) 0 pbcattbl
716 1 ( 0) 1 ( 0) 0 pbcatcol
717 1 ( 8) 1 ( 2) 0 pbcatfmt
718 1 ( 0) 1 ( 0) 0 pbcatvld
719 1 ( 12) 1 ( 2) 0 pbcatedt
735 248 ( 94) 0 ( 0) 0 erd_staraRawData
736 1 ( 0) 1 ( 0) 0 pbcattbl
737 1 ( 0) 1 ( 0) 0 pbcatcol
738 1 ( 8) 1 ( 2) 0 pbcatfmt
739 1 ( 0) 1 ( 0) 0 pbcatvld
740 1 ( 12) 1 ( 2) 0 pbcatedt
741 1 ( 11) 0 ( 0) 0 WeeksOfYearCalendar
======== ========
Total: 176652 table + 146026 index + 70639 free + 312 other = 393629 pages

Adaptive Server Anywhere Information Utility Version 9.0.2.3500
Parse error: DSN 'Franchise_Consolidated' does not exist
Adaptive Server Anywhere Information Utility Version 9.0.2.3500
Database : E:\Franchisee_Consolidation\Franchisee_Consolidated.db
Log file : E:\Franchisee_Consolidation\Franchisee_Consolidated.log
Log mirror: none
Free pages: 1264603
Compressed: No
Page size : 8192
Encrypted : No
Strings padded with blanks for comparisons: No
Respect letter-case when comparing: No ('A' equal to 'a')
Collation sequence: 1252LATIN1 (Code Page 1252, Windows Latin 1, Western)
Java classes installed: No
Database checksums enabled: No


Table Table Index Percent Name
id Pages %used Pages %used of File
----- -------- ----- -------- ----- ------- ----
1 12 ( 87) 7 ( 48) 0 SYSTABLE
2 32 ( 96) 37 ( 70) 0 SYSCOLUMN
3 1 ( 34) 4 ( 9) 0 SYSINDEX
4 1 ( 22) 3 ( 18) 0 SYSIXCOL
5 2 ( 67) 4 ( 41) 0 SYSFOREIGNKEY
6 2 ( 36) 3 ( 67) 0 SYSFKCOL
7 1 ( 1) 2 ( 0) 0 SYSFILE
8 1 ( 6) 1 ( 3) 0 SYSDOMAIN
9 1 ( 12) 2 ( 3) 0 SYSUSERPERM
10 1 ( 89) 5 ( 30) 0 SYSTABLEPERM
11 1 ( 5) 4 ( 3) 0 SYSCOLPERM
12 1 ( 60) 2 ( 25) 0 SYSOPTION
13 1 ( 3) 3 ( 3) 0 SYSGROUP
14 2 ( 8) 1 ( 0) 0 SYSCOLLATION
15 618 ( 96) 15 ( 44) 0 SYSPROCEDURE
16 42 ( 96) 45 ( 80) 0 SYSPROCPARM
17 13 ( 93) 6 ( 43) 0 SYSTRIGGER
18 4 ( 32) 7 ( 57) 0 SYSPROCPERM
19 1 ( 0) 3 ( 0) 0 SYSPUBLICATION
20 1 ( 0) 3 ( 0) 0 SYSARTICLE
21 1 ( 0) 3 ( 0) 0 SYSARTICLECOL
22 1 ( 0) 5 ( 0) 0 SYSREMOTEUSER
23 1 ( 0) 3 ( 0) 0 SYSSUBSCRIPTION
24 1 ( 0) 1 ( 0) 0 SYSUSERMESSAGES
25 1 ( 4) 5 ( 1) 0 SYSUSERTYPE
26 1 ( 0) 2 ( 0) 0 SYSEXTENT
27 1 ( 1) 2 ( 1) 0 SYSREMOTETYPE
28 1 ( 9) 1 ( 4) 0 SYSSQLSERVERTYPE
29 1 ( 5) 1 ( 5) 0 SYSTYPEMAP
30 1 ( 0) 2 ( 0) 0 SYSLOGIN
31 1 ( 0) 2 ( 0) 0 SYSJAR
32 1 ( 0) 5 ( 0) 0 SYSJAVACLASS
33 1 ( 0) 2 ( 0) 0 SYSJARCOMPONENT
34 1 ( 1) 1 ( 0) 0 SYSCOLLATIONMAPPINGS
35 1 ( 0) 1 ( 0) 0 SYSSERVERS
36 1 ( 0) 3 ( 0) 0 SYSEXTERNLOGINS
45 1 ( 0) 3 ( 0) 0 SYSCAPABILITY
46 1 ( 54) 1 ( 36) 0 SYSCAPABILITYNAME
47 1 ( 0) 2 ( 0) 0 SYSREMOTEOPTIONTYPE
48 1 ( 0) 2 ( 0) 0 SYSREMOTEOPTION
49 1 ( 0) 5 ( 0) 0 SYSSYNC
50 1 ( 7) 2 ( 2) 0 SYSEVENTTYPE
51 2 ( 3) 4 ( 0) 0 SYSEVENT
52 1 ( 0) 2 ( 0) 0 SYSSCHEDULE
53 1 ( 0) 1 ( 0) 0 SYSOPTREQUEST
54 1 ( 0) 2 ( 0) 0 SYSOPTREWRITE
55 1 ( 0) 2 ( 0) 0 SYSOPTBLOCK
56 1 ( 0) 2 ( 0) 0 SYSOPTJOINSTRATEGY
57 1 ( 0) 2 ( 0) 0 SYSOPTQUANTIFIER
58 1 ( 0) 4 ( 0) 0 SYSOPTORDER
59 6 ( 97) 2 ( 54) 0 SYSCOLSTAT
60 1 ( 0) 1 ( 0) 0 SYSOPTSTAT
61 1 ( 2) 1 ( 1) 0 SYSATTRIBUTENAME
62 3 ( 60) 4 ( 49) 0 SYSATTRIBUTE
63 1 ( 0) 2 ( 0) 0 SYSWEBSERVICE
64 1 ( 3) 1 ( 1) 0 SYSHISTORY
65 2 ( 78) 8 ( 63) 0 SYSCONSTRAINT
66 1 ( 2) 2 ( 0) 0 SYSCHECK
335 1 ( 0) 0 ( 0) 0 DUMMY
336 1 ( 0) 0 ( 0) 0 SYSINFO
337 1 ( 28) 1 ( 34) 0 RowGenerator
376 1 ( 0) 1 ( 0) 0 rs_lastcommit
377 1 ( 0) 1 ( 0) 0 rs_threads
379 1 ( 0) 1 ( 0) 0 ul_file
380 1 ( 0) 3 ( 0) 0 ul_statement
381 1 ( 0) 2 ( 0) 0 ul_variable
384 1 ( 6) 2 ( 2) 0 ml_user
385 1 ( 6) 2 ( 2) 0 ml_subscription
386 1 ( 24) 2 ( 11) 0 ml_table
387 176 ( 93) 9 ( 80) 0 ml_script
388 1 ( 2) 2 ( 1) 0 ml_script_version
389 1 ( 0) 3 ( 0) 0 ml_connection_script
390 6 ( 85) 14 ( 46) 0 ml_table_script
391 1 ( 17) 1 ( 3) 0 ml_property
392 1 ( 0) 1 ( 0) 0 ml_scripts_modified
395 1 ( 0) 1 ( 0) 0 ml_device
396 1 ( 0) 2 ( 0) 0 ml_device_address
397 1 ( 0) 2 ( 0) 0 ml_listening
398 1 ( 0) 1 ( 0) 0 ml_qa_notifications
399 1 ( 0) 1 ( 0) 0 ml_qa_repository
400 1 ( 0) 1 ( 0) 0 ml_qa_status_history
401 1 ( 0) 1 ( 0) 0 ml_qa_repository_staging
402 1 ( 0) 1 ( 0) 0 ml_qa_status_staging
403 1 ( 0) 2 ( 0) 0 ml_qa_delivery
404 1 ( 0) 2 ( 0) 0 ml_qa_repository_props
406 1 ( 0) 1 ( 0) 0 ml_qa_global_props
407 2 ( 72) 1 ( 52) 0 EXCLUDEOBJECT
408 1 ( 0) 1 ( 0) 0 migrate_remote_table_list
409 1 ( 0) 1 ( 0) 0 migrate_sql_defn
410 1 ( 0) 1 ( 0) 0 migrate_remote_fks_list
411 1 ( 0) 1 ( 0) 0 ix_consultant_master
412 1 ( 0) 2 ( 0) 0 ix_consultant_query_text
413 1 ( 0) 2 ( 0) 0 ix_consultant_query_phase
414 1 ( 0) 2 ( 0) 0 ix_consultant_workload
415 1 ( 0) 2 ( 0) 0 ix_consultant_query_index
416 1 ( 0) 2 ( 0) 0 ix_consultant_index
417 1 ( 0) 2 ( 0) 0 ix_consultant_ixcol
418 1 ( 0) 2 ( 0) 0 ix_consultant_affected_columns
419 1 ( 0) 2 ( 0) 0 ix_consultant_log
420 1 ( 0) 1 ( 0) 0 ix_consultant_capture
424 1 ( 17) 1 ( 3) 0 spt_jdatatype_info
425 1 ( 35) 1 ( 9) 0 jdbc_function_escapes
427 2 ( 55) 1 ( 19) 0 spt_mda
428 2 ( 3) 1 ( 0) 0 spt_jtext
430 1 ( 7) 1 ( 3) 0 spt_jdbc_conversion
437 1 ( 12) 1 ( 7) 0 spt_collation_map
438 1 ( 0) 1 ( 0) 0 pbcattbl
439 1 ( 0) 1 ( 0) 0 pbcatcol
440 1 ( 0) 1 ( 0) 0 pbcatfmt
441 1 ( 0) 1 ( 0) 0 pbcatvld
442 1 ( 0) 1 ( 0) 0 pbcatedt
443 1 ( 64) 2 ( 6) 0 ctr_courses
444 5 ( 85) 2 ( 32) 0 clt_courses
445 1044 ( 97) 575 ( 67) 0 clt_actanswers
446 16 ( 57) 4 ( 71) 0 clt_actscores
447 2672 ( 97) 1623 ( 66) 0 clt_satanswers
448 188 ( 93) 121 ( 65) 0 clt_satgridanswers
449 46 ( 89) 20 ( 59) 0 clt_satscores
450 1 ( 0) 1 ( 0) 0 hmis_param
451 100 ( 93) 59 ( 66) 0 clt_billingparties
452 45 ( 86) 18 ( 49) 0 clt_creditcards
453 1 ( 12) 1 ( 5) 0 sys_user_report
454 1 ( 0) 0 ( 0) 0 hmis_user
455 1 ( 75) 2 ( 8) 0 ctr_discount
456 125 ( 90) 26 ( 42) 0 clt_testdata
457 1 ( 0) 2 ( 0) 0 clt_courses_chg
458 1 ( 0) 1 ( 0) 0 Messages
459 272 ( 77) 79 ( 72) 0 clt_clients
460 2346 ( 96) 852 ( 67) 0 clt_scheduling
461 673 ( 96) 550 ( 61) 0 clt_phones
462 646 ( 96) 509 ( 72) 0 clt_status
463 1371 ( 96) 785 ( 76) 0 clt_addresses
464 11970 ( 97) 5286 ( 81) 1 clt_charges
465 748 ( 96) 141 ( 57) 0 clt_interimconference
466 794 ( 96) 191 ( 74) 0 clt_inq_cch
467 1 ( 0) 2 ( 0) 0 clt_testselection
468 2 ( 50) 2 ( 2) 0 ctr_preferences
469 1 ( 0) 2 ( 0) 0 clt_satanalysis_results
470 1277 ( 96) 698 ( 60) 0 clt_hmpe
471 32 ( 94) 8 ( 76) 0 sys_answerkey
472 1 ( 28) 1 ( 12) 0 sys_attendcodes
473 2 ( 51) 2 ( 46) 0 sys_hmpe_sets
474 1 ( 18) 1 ( 8) 0 sys_iota
475 1 ( 8) 1 ( 2) 0 sys_irirate
476 1 ( 0) 1 ( 0) 0 sys_level
477 1 ( 29) 1 ( 5) 0 sys_levels
478 4 ( 92) 2 ( 36) 0 sys_math_curriculum
479 1 ( 9) 1 ( 2) 0 sys_math_placementexam
480 1 ( 19) 1 ( 4) 0 sys_math_publisher
481 2 ( 59) 1 ( 23) 0 sys_math_skills
482 4 ( 95) 3 ( 52) 0 sys_math_subskill
483 1 ( 0) 1 ( 0) 0 sys_math_version
484 1 ( 8) 1 ( 2) 0 sys_mathph
485 3 ( 79) 1 ( 27) 0 sys_phonics_curriculum
486 1 ( 39) 1 ( 7) 0 sys_phonics_skills
487 1 ( 0) 1 ( 0) 0 sys_phonics_phonics
488 1 ( 7) 1 ( 2) 0 sys_phonics_phonicspe
489 1 ( 22) 1 ( 4) 0 sys_phonics_publish
490 1 ( 72) 1 ( 39) 0 sys_phonics_subskill
491 2 ( 52) 1 ( 12) 0 sys_vendors
492 1 ( 44) 1 ( 6) 0 sys_report_dwobject_procs
493 2 ( 66) 1 ( 38) 0 sys_reports
494 1 ( 73) 2 ( 30) 0 sys_rprt_log
495 40 ( 93) 8 ( 78) 0 sys_sat_description
496 32 ( 73) 6 ( 61) 0 sys_sat_conversion
497 4 ( 74) 1 ( 49) 0 sys_sat_psat_act_codes
498 3 ( 71) 1 ( 45) 0 sys_satgridanswers
499 4 ( 27) 0 ( 0) 0 sys_sequance
500 3 ( 69) 0 ( 0) 0 sys_sdct
501 1 ( 40) 1 ( 14) 0 sys_sortr
502 1 ( 41) 0 ( 0) 0 sys_sshat
503 1 ( 41) 0 ( 0) 0 sys_sshahug
504 1 ( 41) 0 ( 0) 0 sys_sshahlg
505 1 ( 0) 2 ( 0) 0 clt_act_results
506 48 ( 91) 13 ( 81) 0 sys_act_row_to_scaled
507 1 ( 0) 2 ( 0) 0 clt_letters
508 1 ( 0) 2 ( 0) 0 ctr_letters
509 1 ( 78) 2 ( 6) 0 clt_actanalysis_results
510 292 ( 95) 112 ( 59) 0 clt_changes
511 1 ( 18) 2 ( 5) 0 ctr_holidays
512 632 ( 96) 316 ( 76) 0 clt_payments
513 1 ( 0) 2 ( 0) 0 clt_payments_details
514 240 ( 94) 90 ( 64) 0 clt_rates
515 1 ( 0) 1 ( 0) 0 ctr_billing_messages
516 2 ( 27) 2 ( 2) 0 clt_billing_messages
517 1 ( 0) 2 ( 0) 0 clt_discount
518 112 ( 93) 47 ( 58) 0 clt_finance
519 1 ( 0) 1 ( 0) 0 security_info
520 1 ( 0) 2 ( 0) 0 ctr_schools
521 1 ( 0) 2 ( 0) 0 ctr_schools_districts
522 1 ( 0) 2 ( 0) 0 ctr_schools_people
523 2 ( 90) 2 ( 52) 0 ctr_codes_referral
524 1 ( 11) 1 ( 1) 0 sys_schedule_templates
525 1 ( 5) 1 ( 1) 0 sys_codes_drop
526 169 ( 96) 34 ( 65) 0 clt_initialconference
527 1 ( 0) 0 ( 0) 0 batch_user
528 1 ( 0) 0 ( 0) 0 batchdw
529 1 ( 0) 0 ( 0) 0 batchtim
530 1 ( 0) 1 ( 0) 0 batch_report
531 1 ( 0) 1 ( 0) 0 hmis_rprt_param_copy
532 1 ( 0) 2 ( 0) 0 hmis_rprt_param
533 1 ( 0) 2 ( 0) 0 clt_attend_summary
534 16 ( 73) 2 ( 22) 0 clt_behavior
535 1 ( 7) 1 ( 2) 0 sys_codes_appointments
536 1 ( 15) 1 ( 7) 0 sys_codes_belongsto
537 1 ( 2) 1 ( 1) 0 sys_codes_addresstype
538 1 ( 8) 1 ( 1) 0 sys_codes_phonetype
539 1 ( 1) 1 ( 0) 0 sys_codes_countries
540 1 ( 4) 1 ( 1) 0 sys_codes_salutation
541 1 ( 6) 1 ( 2) 0 sys_codes_statuscodes
542 1 ( 4) 1 ( 2) 0 sys_codes_grades
543 1 ( 6) 1 ( 1) 0 sys_codes_charges_trantype
544 1 ( 4) 1 ( 1) 0 sys_codes_attend
545 1 ( 31) 2 ( 11) 0 ctr_codes_inq_reason
546 7 ( 85) 5 ( 45) 0 clt_testbehavior
547 1 ( 7) 1 ( 1) 0 sys_ic_prep_reports
548 1 ( 0) 3 ( 0) 0 clt_ic_information
549 1 ( 79) 2 ( 18) 0 ctr_staff_position_code
550 1 ( 61) 3 ( 12) 0 ctr_staff_positions
551 16 ( 69) 6 ( 55) 0 ctr_staff
552 1 ( 26) 2 ( 5) 0 ctr_staff_events
553 2 ( 81) 2 ( 30) 0 ctr_phones
554 1 ( 8) 1 ( 2) 0 sys_codes_ininterest
555 2 ( 56) 2 ( 12) 0 ctr_addresses
556 1 ( 25) 1 ( 7) 0 sys_codes_states
557 1 ( 0) 2 ( 0) 0 ctr_staff_compensation
558 1 ( 0) 2 ( 0) 0 ctr_staff_payroll
559 2 ( 14) 1 ( 1) 0 ctr_central
560 1 ( 3) 1 ( 1) 0 sys_codes_contactby
561 1 ( 0) 2 ( 0) 0 ctr_school_addresses
562 1 ( 0) 2 ( 0) 0 ctr_school_phones
563 1 ( 0) 2 ( 0) 0 ctr_schools_events
564 1 ( 0) 2 ( 0) 0 ctr_schools_contacts
565 1 ( 0) 1 ( 0) 0 ctr_test_list
566 1 ( 1) 1 ( 0) 0 sys_codes_absences_not_used
567 1 ( 2) 1 ( 1) 0 sys_codes_inq_types
568 1 ( 4) 1 ( 2) 0 sys_writingsample
569 1 ( 1) 1 ( 1) 0 sys_codes_eventtype
570 1 ( 2) 1 ( 1) 0 sys_codes_maritalstatus
571 1 ( 1) 1 ( 1) 0 sys_codes_ethnicity
572 1 ( 9) 1 ( 5) 0 sys_grade_suffix
573 1 ( 71) 2 ( 16) 0 ctr_codes_occupations
574 1 ( 2) 1 ( 1) 0 sys_codes_apptstatus
575 1 ( 3) 1 ( 2) 0 sys_codes_charge_sources
576 1 ( 5) 1 ( 2) 0 sys_codes_paymenttype
577 1 ( 4) 1 ( 1) 0 sys_codes_paymethod
578 1 ( 6) 1 ( 2) 0 sys_ph_study_skills
579 1 ( 36) 1 ( 13) 0 sys_ph_writing
580 1 ( 6) 1 ( 2) 0 sys_phonics1
581 1 ( 2) 1 ( 1) 0 sys_ph_handwriting
582 1 ( 4) 1 ( 2) 0 sys_rosner
583 1 ( 10) 1 ( 2) 0 sys_ph_phonics
584 2 ( 72) 2 ( 39) 0 ctr_iri
585 1 ( 3) 1 ( 1) 0 sys_code_positionevent
586 1 ( 11) 2 ( 2) 0 ctr_attendance
587 1 ( 0) 1 ( 0) 0 security_apps
588 1 ( 0) 1 ( 0) 0 security_groupings
589 1 ( 0) 1 ( 0) 0 security_users
590 1 ( 0) 2 ( 0) 0 clt_hppe
591 1 ( 31) 1 ( 13) 0 sys_iri_by_month
592 1 ( 37) 1 ( 2) 0 sys_initial_conference_prep_form
593 1 ( 5) 1 ( 1) 0 sys_codes_form
594 4 ( 89) 3 ( 46) 0 sys_ph_svmpt
595 1 ( 2) 1 ( 0) 0 sys_rating_wold
596 76 ( 89) 25 ( 55) 0 clt_pres_hours
597 3 ( 89) 1 ( 61) 0 sys_ph_sort_voc_rdg
598 1 ( 0) 0 ( 0) 0 inq_vol
599 1 ( 2) 1 ( 0) 0 sys_grade_conv
600 1 ( 4) 1 ( 1) 0 sys_reading_readiness
601 1 ( 8) 1 ( 1) 0 sys_chall
602 1 ( 66) 1 ( 21) 0 sys_ph_iricomp_rdg_nonnum
603 1 ( 37) 0 ( 0) 0 sys_ph_miscues_voc
604 1 ( 6) 1 ( 2) 0 sys_ph_miscues_voc_nonnum
605 1 ( 6) 1 ( 2) 0 sys_ph_rate_rdg_nonnum
606 2 ( 88) 1 ( 57) 0 sys_ph_ach_voc_rdg
607 2 ( 55) 1 ( 31) 0 sys_ph_rate_rdg
608 392 ( 96) 177 ( 66) 0 clt_inquiryaction
609 1 ( 14) 1 ( 5) 0 sys_ph_sort_voc_rdg_nonnum
610 1 ( 0) 1 ( 0) 0 erd_center_information
611 1 ( 0) 1 ( 0) 0 erd_urgency_words
612 1 ( 9) 2 ( 0) 0 ctr_notes
613 87 ( 86) 14 ( 43) 0 clt_notes
614 1 ( 1) 2 ( 0) 0 ctr_staff_notes
615 1 ( 0) 1 ( 0) 0 erd_seq_numb
616 1 ( 5) 1 ( 1) 0 sys_rating_ach_test
617 1 ( 4) 1 ( 1) 0 sys_codes_disposition
618 7 ( 85) 2 ( 91) 0 ctr_fees
619 1 ( 70) 2 ( 17) 0 ctr_services
620 1 ( 3) 1 ( 1) 0 sys_codes_subconreason
621 1 ( 25) 1 ( 3) 0 sys_codes_sat_testcodes
622 1 ( 13) 1 ( 1) 0 sys_codes_act_testcodes
623 1 ( 0) 1 ( 0) 0 erd_towns
624 1 ( 72) 1 ( 18) 0 sys_dt_achtest_norms_default
625 1 ( 0) 1 ( 0) 0 inq_newclientid
626 4 ( 87) 2 ( 32) 0 ctr_monthly_exp
627 1 ( 5) 1 ( 1) 0 sys_pres_hrs_minmax
628 50 ( 93) 34 ( 60) 0 ctr_owns_component
629 1 ( 0) 2 ( 0) 0 ul_user
630 1 ( 0) 2 ( 0) 0 ul_table
631 1 ( 0) 1 ( 0) 0 ul_script
632 1 ( 0) 2 ( 0) 0 ul_connection_script
633 1 ( 0) 3 ( 0) 0 ul_table_script
634 1 ( 0) 1 ( 0) 0 ul_scripts_modified
635 69 ( 93) 76 ( 69) 0 ctr_own_master
636 1 ( 7) 1 ( 1) 0 sys_statements
637 1 ( 8) 1 ( 2) 0 sys_codes_services
638 56 ( 81) 2 ( 39) 0 sys_cur_master
639 1 ( 17) 1 ( 6) 0 sys_component_form
640 1 ( 4) 1 ( 1) 0 sys_cur_classifications
641 1 ( 0) 1 ( 0) 0 sys_cur_component_guidelines_skills
642 6 ( 90) 3 ( 65) 0 sys_cur_master_relates_to_school
643 48 ( 77) 11 ( 61) 0 sys_cur_component
644 699 ( 95) 230 ( 82) 0 clt_statement
645 1 ( 0) 1 ( 0) 0 SYS_Version
646 1 ( 0) 1 ( 0) 0 ctr_codes_creditcards
647 88 ( 94) 0 ( 0) 0 sys_math_newskill
648 1 ( 97) 1 ( 48) 0 sys_ph_sdct
649 1 ( 0) 1 ( 0) 0 pbcattbl
650 1 ( 0) 1 ( 0) 0 pbcatcol
651 1 ( 0) 1 ( 0) 0 pbcatfmt
652 1 ( 0) 1 ( 0) 0 pbcatvld
653 1 ( 0) 1 ( 0) 0 pbcatedt
654 1 ( 2) 1 ( 1) 0 sys_codes_discount
655 279 ( 96) 100 ( 70) 0 clt_appointments
656 1 ( 0) 1 ( 0) 0 STF_Teachers
657 1 ( 0) 1 ( 0) 0 STF_PayCode
658 1 ( 0) 1 ( 0) 0 STF_HoursWorked
659 33 ( 84) 24 ( 68) 0 ctr_teacher_hours
660 1 ( 0) 1 ( 0) 0 SYS_ADI
661 1 ( 0) 1 ( 0) 0 SYS_ADISub
663 532 ( 96) 154 ( 63) 0 clt_payments_audit
664 1 ( 13) 1 ( 5) 0 sys_ph_phonics_hours
665 1 ( 84) 1 ( 11) 0 sys_reports_batch
666 24 ( 73) 6 ( 68) 0 sys_ph_iricomp_rdg
667 1 ( 95) 1 ( 47) 0 sys_tier1_addreading
668 1 ( 42) 1 ( 8) 0 sys_tier1_corereader
669 1 ( 18) 1 ( 9) 0 sys_tier1_hw
670 1 ( 20) 1 ( 10) 0 sys_tier1_phonics
671 1 ( 33) 1 ( 6) 0 sys_tier1_vocab
672 1 ( 17) 1 ( 8) 0 sys_tier1_vp
673 1 ( 0) 1 ( 0) 0 sys_statement_details
674 3 ( 88) 3 ( 34) 0 sys_tier1_corereader_component
675 1 ( 30) 1 ( 14) 0 sys_tier1_vocab_component
676 2 ( 9) 2 ( 2) 0 clt_payment_allocation
677 1 ( 1) 1 ( 0) 0 security_template
678 1 ( 0) 1 ( 0) 0 pbcattbl
679 1 ( 0) 1 ( 0) 0 pbcatcol
680 1 ( 0) 1 ( 0) 0 pbcatfmt
681 1 ( 0) 1 ( 0) 0 pbcatvld
682 1 ( 0) 1 ( 0) 0 pbcatedt
683 1 ( 80) 1 ( 17) 0 sys_iri_defaults
684 1 ( 1) 1 ( 0) 0 Fran_Reports
685 2 ( 5) 2 ( 0) 0 Fran_Reports_Definitions
686 1 ( 0) 2 ( 0) 0 Fran_Reports_Activity
687 1 ( 2) 1 ( 1) 0 sys_rating_boehm
688 1 ( 5) 1 ( 1) 0 sys_codes_schoolposition
689 1 ( 15) 1 ( 4) 0 Sys_ACT_Master
690 16 ( 55) 6 ( 45) 0 Sys_ACT_Scaled_Score
691 1 ( 25) 1 ( 6) 0 Sys_SAT_Master
692 1 ( 87) 1 ( 12) 0 Sys_SAT_Question_Codes
693 20 ( 72) 28 ( 37) 0 Sys_SAT_Answers
694 5 ( 86) 2 ( 86) 0 Sys_SAT_Score_Conversion
695 6 ( 92) 2 ( 63) 0 Sys_SAT_Essay_Score_Conversion
696 1 ( 0) 0 ( 0) 0 Fran_Reports_Requests
697 56 ( 59) 34 ( 87) 0 Sys_ACT_Writing
698 1 ( 0) 1 ( 0) 0 clt_lea_invoices_payment
699 16 ( 70) 6 ( 36) 0 clt_lea_invoices
700 24 ( 95) 14 ( 50) 0 Ctr_Staff_Schedule
701 7 ( 94) 6 ( 44) 0 Ctr_Staff_Vacation
702 2691 ( 96) 1873 ( 71) 0 Ctr_Teacher_Schedule
703 19 ( 76) 12 ( 45) 0 Clt_Study_Profile
704 1 ( 23) 2 ( 3) 0 ctr_NCLB_Agencies
705 1 ( 0) 2 ( 0) 0 clt_deleted_charges
706 1 ( 0) 2 ( 0) 0 ctr_student_programs_templates
707 1 ( 0) 2 ( 0) 0 clt_conferenceattendees
708 1 ( 0) 1 ( 0) 0 ctr_emails
709 1 ( 0) 1 ( 0) 0 ctr_distribution_lists
710 1 ( 0) 1 ( 0) 0 ctr_emailsbylists
711 4 ( 82) 1 ( 53) 0 Sys_ACT_Question_Codes
712 56 ( 99) 61 ( 66) 0 Sys_ACT_Answers
713 16 ( 62) 6 ( 45) 0 Sys_ACT_Percent
714 1 ( 0) 2 ( 0) 0 Ctr_SalesTaxes
715 17 ( 70) 5 ( 42) 0 sys_writing_newskill
716 1 ( 6) 1 ( 3) 0 sys_writing_skill
717 1 ( 26) 1 ( 14) 0 sys_writing_subskill
718 1 ( 0) 2 ( 0) 0 clt_satprescribedhours
719 1 ( 1) 1 ( 0) 0 sys_defaults
720 1 ( 0) 3 ( 0) 0 ctr_defaults
721 1 ( 0) 1 ( 0) 0 Fran_Reports_Sent
722 1 ( 0) 1 ( 0) 0 Sys_PSAT_Master
723 1 ( 38) 1 ( 6) 0 Sys_PSAT_Question_Codes
724 2 ( 50) 5 ( 14) 0 Sys_PSAT_Answers
725 1 ( 33) 2 ( 6) 0 Sys_PSAT_Score_Conversion
726 1 ( 4) 2 ( 0) 0 Clt_PSAT_Score
727 3 ( 70) 2 ( 39) 0 Clt_PSAT_Answers
728 24 ( 81) 7 ( 66) 0 sys_phonics_newskill
729 1 ( 0) 2 ( 0) 0 clt_InquiryImage
731 1 ( 0) 1 ( 0) 0 clt_sat_goalscores
732 1 ( 0) 1 ( 0) 0 clt_act_goalscores
733 1 ( 0) 1 ( 0) 0 clt_actprescribedhours
734 1 ( 0) 1 ( 0) 0 clt_quickbook_accounts
735 1 ( 42) 1 ( 7) 0 sys_quickbook_accounts
736 1 ( 0) 1 ( 0) 0 clt_qb_request
737 1 ( 0) 1 ( 0) 0 clt_qb_pl_report_data
738 1 ( 0) 1 ( 0) 0 clt_qb_errlog
739 1 ( 24) 1 ( 5) 0 sys_quickbook_default_maping
740 1 ( 39) 1 ( 7) 0 clt_qb_map_expenses
741 1 ( 0) 1 ( 0) 0 ctr_goals
742 1 ( 15) 1 ( 5) 0 STF_OpsManagers
743 1 ( 0) 2 ( 0) 0 mobilelink_setup
======== ========
Total: 32703 table + 15755 index + 1264603 free + 47 other = 1313108 pages


Chris Keating (Sybase iAnywhere) Posted on 2007-10-11 20:16:14.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink
References: <470e1693$1@forums-1-dub> <470e2fb7.2b39.1681692777@sybase.com>
In-Reply-To: <470e2fb7.2b39.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <470e848e$1@forums-1-dub>
Date: 11 Oct 2007 13:16:14 -0700
X-Trace: forums-1-dub 1192133774 10.25.98.110 (11 Oct 2007 13:16:14 -0700)
X-Original-Trace: 11 Oct 2007 13:16:14 -0700, keating-d620.sybase.com
Lines: 55
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6414
Article PK: 4742

Free pages are at fault (see the last line of both outputs). Here is the
breakdown

PAGES

Mobilink Dbremote
-------- ---------
Table 32,703 176,652
Index 176,652 146,026
Free 1,264,603 70,639 <-- free pages
Other 47 321
--------- ---------
Total 1,313,108 393,629


You will also note that you are running different versions of software
(based on the dbinfo version).

The question is why is ML seeing more free pages? Are you doing more
deletes which free pages? Or have you pre-allocated space?

Herman Miller wrote:
> See attachments. Let me know.
>
>
>> Is this size determined after the database has been
>> stopped i.e., the checkpoint log cleaned up?
>>
>> What is the output of dbinfo with the -u option for both
>> databases?
>>
>> i.e.,
>> dbinfo -c "<conn_str_mobilink_db>" -u -o Mobilink.txt
>> dbinfo -c "<conn_str_sqlremote_db>" -u -o SqlRemote.txt
>>
>>
>>
>> Herman wrote:
>>> I have SQL Remote setup to upload data to a consolidated
>>> database.
>>> I also have Mobilink setup to upload data to a different
>>> consolidated database.
>>>
>>> Both methods upload the exact same tables and columns.
>>> Based on the number of rows in the tables, the Mobilink
>>> consolidated database contains less rows in total then
>>> the SQL Remote consolidated database. Both have a page
>>> size of 8192, however the actual database size seems to
>>> be considerably larger. SQL Remote db size alittle over
>>> 3gb and Mobilink alittle over 10gb. I compared rows in
>>> tables, columns in tables, indexes, foreign keys, how
>>> else can I determine what is causing this database to be
>>> so much larger or is their something in Mobilink that
>> causes this?


Herman Posted on 2007-10-12 12:55:44.0Z
Sender: 4780.470f6d08.1804289383@sybase.com
From: Herman
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470f6ed0.479d.1681692777@sybase.com>
References: <470e848e$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Oct 2007 05:55:44 -0700
X-Trace: forums-1-dub 1192193744 10.22.241.41 (12 Oct 2007 05:55:44 -0700)
X-Original-Trace: 12 Oct 2007 05:55:44 -0700, 10.22.241.41
Lines: 59
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6418
Article PK: 4746

How can I determine preallocated space?

> Free pages are at fault (see the last line of both
> outputs). Here is the breakdown
>
> PAGES
>
> Mobilink Dbremote
> -------- ---------
> Table 32,703 176,652
> Index 176,652 146,026
> Free 1,264,603 70,639 <-- free pages
> Other 47 321
> --------- ---------
> Total 1,313,108 393,629
>
>
> You will also note that you are running different versions
> of software (based on the dbinfo version).
>
> The question is why is ML seeing more free pages? Are you
> doing more deletes which free pages? Or have you
> pre-allocated space?
>
>
> Herman Miller wrote:
> > See attachments. Let me know.
> >
> >
> >> Is this size determined after the database has been
> >> stopped i.e., the checkpoint log cleaned up?
> >>
> >> What is the output of dbinfo with the -u option for
> both >> databases?
> >>
> >> i.e.,
> >> dbinfo -c "<conn_str_mobilink_db>" -u -o Mobilink.txt
> >> dbinfo -c "<conn_str_sqlremote_db>" -u -o SqlRemote.txt
> >>
> >>
> >>
> >> Herman wrote:
> >>> I have SQL Remote setup to upload data to a
> consolidated >>> database.
> >>> I also have Mobilink setup to upload data to a
> different >>> consolidated database.
> >>>
> >>> Both methods upload the exact same tables and columns.
> >>> Based on the number of rows in the tables, the
> Mobilink >>> consolidated database contains less rows in
> total then >>> the SQL Remote consolidated database. Both
> have a page >>> size of 8192, however the actual database
> size seems to >>> be considerably larger. SQL Remote db
> size alittle over >>> 3gb and Mobilink alittle over 10gb.
> I compared rows in >>> tables, columns in tables, indexes,
> foreign keys, how >>> else can I determine what is causing
> this database to be >>> so much larger or is their
> something in Mobilink that >> causes this?