ca.portal.admin

ADS SQL Access Module problems

Discussion created by ca.portal.admin on Jul 6, 2006
Hello All:

Kay Rozeboom and I are having difficulty getting an ADS dialog to access
an SQL access module. I'm sure my explanation will create more
questions,
but the gist is this:

ADS dialog with embedded SQL which can be executed successfully in OCF.
Compiled the dialog, the created the access module in the same schema
indicated in ADSC Database Specifications screen.

When the dialog is executed, it always returns an SQLSTATE=42503
(42=Syntax error.... 503=Authorization failure) and SQL error message
DB00552 1 T26018 C-4M321: Missing authorization for <access- module
name>.

What we can't figure out is why?

Thanks,

Tim Gortner
State of Iowa
Department of Human Services

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Maximum Page Size for IDMS Database Files
"Hi,



We look as though we will be running on new disks in the future that
would be formatted as 'MOD 9' rather than our current '3390' style. This
would allow us to increase our page sizes for the IDMS files. We are
running 16.0 SP1 and the manual suggests that 32764 is the maximum
allowed by IDMS. Is this true or could we go bigger if warranted?



Thanks



Chris Wood

Alberta Department of Energy

CANADA

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Maximum Page Size for IDMS Database Files
"Chris,
You are still limited to 32764 bytes as a page size. Although if you use
that page size you are wasting a lot of DASD. For a 3390, the track size
is 56664 bytes, so the optimum page size would be 27996. This would
allow 2 pages per track. If you used the max of 32764 you only get 1
page per track and you have wasted space of almost 24K bytes per track.


Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/

Outcomes