I'm running R16 SP4. I'm getting an err
Illustrious Listers:
I'm running R16 SP4. I'm getting an error 0353 most likely caused by a record length mis-match with the subschema since there are no indexes or other sets involved. The record is a CALC record. There are several good records in the area; but at least one bad one. My question: how do I find the bad one(s) and get rid of it/them? I ran a DB-AUDIT and it showed no errors; but DMLO , OLQ, and CULPRIT all throw the error; so I know it's real. I'm afraid my IDMS skills are getting pretty rusty since most of my time these days is spent working on another DBMS. Any help would be most appreciated.
Thanks,
Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
------------------------------ IMPORTANT NOTICE ------------------------------
This email transmission and any accompanying attachments contain confidential
information intended only for the use of the individual or entity named above.
Any dissemination, distribution, copying or action taken in reliance on the
contents of this email by anyone other than the intended recipient is strictly
prohibited. If you have received this email in error please immediately delete
it and notify sender at the above email address.
------------------------------ IMPORTANT NOTICE ------------------------------
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: 0353 on Calc Record with no index or sets
"Roger,
DBAUDIT is seeing a different subschema than are DMLO/OLQ/Culprit. That
is a significant clue. Do you punch/link subschemas into a LOADLIB that
DBAUDIT is using?
Using the subschema that DBAUDIT is currently seeing will also give you
the opportunity to get rid of the invalid records.
Jim Ritterbusch
Roger Lawrence wrote:
I'm running R16 SP4. I'm getting an err
Illustrious Listers:
I'm running R16 SP4. I'm getting an error 0353 most likely caused by a record length mis-match with the subschema since there are no indexes or other sets involved. The record is a CALC record. There are several good records in the area; but at least one bad one. My question: how do I find the bad one(s) and get rid of it/them? I ran a DB-AUDIT and it showed no errors; but DMLO , OLQ, and CULPRIT all throw the error; so I know it's real. I'm afraid my IDMS skills are getting pretty rusty since most of my time these days is spent working on another DBMS. Any help would be most appreciated.
Thanks,
Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: 0353 on Calc Record with no index or sets
"Roger,
DBAUDIT is seeing a different subschema than are DMLO/OLQ/Culprit. That
is a significant clue. Do you punch/link subschemas into a LOADLIB that
DBAUDIT is using?
Using the subschema that DBAUDIT is currently seeing will also give you
the opportunity to get rid of the invalid records.
Jim Ritterbusch
Roger Lawrence wrote:
I'm running R16 SP4. I'm getting an err
Illustrious Listers:
I'm running R16 SP4. I'm getting an error 0353 most likely caused by a record length mis-match with the subschema since there are no indexes or other sets involved. The record is a CALC record. There are several good records in the area; but at least one bad one. My question: how do I find the bad one(s) and get rid of it/them? I ran a DB-AUDIT and it showed no errors; but DMLO , OLQ, and CULPRIT all throw the error; so I know it's real. I'm afraid my IDMS skills are getting pretty rusty since most of my time these days is spent working on another DBMS. Any help would be most appreciated.
Thanks,
Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
0353 on Calc Record with no index or sets
"Thanks to everyone who responded to my plea for help. I found the errant r=
ecord by eye-balling the pages. I genned the schema/subschema with the old=
version of the record and used DMLO to CALC to it and erase it. Problem =
solved.=0D=0A=20=0D=0AYou all are, as usual, the best!=0D=0A=20=0D=0ARoger =
C. Lawrence=0D=0ADatabase Administrator=0D=0ASeminole Electric Cooperative,=
Inc.=0D=0ATampa, Fl.=0D=0A813.739.1518=0D=0A=5F =5F =5F =5F =5F =5F =5F =5F=
=5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F=
=5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F=
=5F=0D=0A=0D=0A** NOTICE **=0D=0AThis e-mail message, including any attach=
ments, is for the sole use of the intended=20=0D=0Arecipient(s) and may con=
tain confidential, proprietary and privileged information.=20=0D=0AAny un-a=
uthorized review, copying, use, disclosure, or distribution is prohibited. =0D=
=0AIf you are not the intended recipient, please contact the sender by repl=
y e-mail and=20=0D=0Adestroy all copies of the original message.=0D=0A=5F =5F=
=5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F=
=5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F =5F=
=5F =5F =5F =5F =5F =5F =5F=0D=0A
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Former Cullinet Employees Only - Invitation to Linkedin.com
"Hi All,
Forgive me for posting a non-technical post.
Jim Intner, a former Cullinet employee like myself, has set up a
LINKEDIN.COM Cullinet Group for former Cullinet Employees.
Please join us and Linkedin to catch up perhaps with old business friends
and of course to potentially increase your networking:
http://www.linkedin.com/groupsDirectory?results=&sik=1228840189067
Happy Holidays,
Joe Perkins PMP
Service is My Line Inc.
Berkeley, CA
530.260.0165 Cell
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Former Cullinet Employees Only - Invitation to Linkedin.com
"Hi All,
Forgive me for posting a non-technical post.
Jim Intner, a former Cullinet employee like myself, has set up a
LINKEDIN.COM Cullinet Group for former Cullinet Employees.
Please join us and Linkedin to catch up perhaps with old business friends
and of course to potentially increase your networking:
http://www.linkedin.com/groupsDirectory?results=&sik=1228840189067
Happy Holidays,
Joe Perkins PMP
Service is My Line Inc.
Berkeley, CA
530.260.0165 Cell
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
"How to display Security Definitions, etc"
"Hi,
At our shop, the IDMS responsibilities have been split between the DBA and
the Sysprog. The sysprog has SYSADMIN access, but I do not.
I would like to know what access I need on my userid so that I can display
security definitions, resources, etc etc, as I would like to learn more
about how IDMS all fits together.
For example, when I go into OCF, connect to system, and display my userid,
I can only see this:
OCF 15.0 ONLINE IDMS NO ERRORS DICT=SYSTEM 1/10
DIS USER U310781;
*+ Status = 0 SQLSTATE = 00000
*+ CREATE USER ""U310781""
*+ USER IS ACTIVE
*+ NAME 'M BAKER'
*+ PASSWORD ASSIGNED
*+ PROFILE NULL
*+ DATE CREATED 2006-03-01-10.01.16.391091 BY U256573
*+ DATE LAST UPDATED 2008-12-10-14.31.56.008414 BY U305740
*+ ;
However, when our sysprog issues the same command against my userid, we
get 204 lines listing all of my particular access rights.
Could someone please explain what exactly we need to do so that our
sysprog can grant me display rights, so that I can view my own access
rights, and all the other types of things setup in IDMS, etc.
Thanks very much.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
"How to display Security Definitions, etc"
"Hi,
At our shop, the IDMS responsibilities have been split between the DBA and
the Sysprog. The sysprog has SYSADMIN access, but I do not.
I would like to know what access I need on my userid so that I can display
security definitions, resources, etc etc, as I would like to learn more
about how IDMS all fits together.
For example, when I go into OCF, connect to system, and display my userid,
I can only see this:
OCF 15.0 ONLINE IDMS NO ERRORS DICT=SYSTEM 1/10
DIS USER U310781;
*+ Status = 0 SQLSTATE = 00000
*+ CREATE USER ""U310781""
*+ USER IS ACTIVE
*+ NAME 'M BAKER'
*+ PASSWORD ASSIGNED
*+ PROFILE NULL
*+ DATE CREATED 2006-03-01-10.01.16.391091 BY U256573
*+ DATE LAST UPDATED 2008-12-10-14.31.56.008414 BY U305740
*+ ;
However, when our sysprog issues the same command against my userid, we
get 204 lines listing all of my particular access rights.
Could someone please explain what exactly we need to do so that our
sysprog can grant me display rights, so that I can view my own access
rights, and all the other types of things setup in IDMS, etc.
Thanks very much.
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
"Re: How to display Security Definitions, etc"
"is your sysadmin connecting to SYSTEM as well? (or does he have a profile
that sends him/her elsewhere) - if i recall, some privileges are stored in
the sql catalog - others in DDLDML<?!> - so where you are connected mignt
influence what you can see!
ps - are there any vacant IUA board seats? i know a GREAT way the IUA can
make some money ... being headquartered in Chicago .....
Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com
The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
"Re: [IDMSVENDOR-L] How to display Security Definitions, etc"
"is your sysadmin connecting to SYSTEM as well? (or does he have a profile
that sends him/her elsewhere) - if i recall, some privileges are stored in
the sql catalog - others in DDLDML<?!> - so where you are connected mignt
influence what you can see!
ps - are there any vacant IUA board seats? i know a GREAT way the IUA can
make some money ... being headquartered in Chicago .....
Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com
The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
"Re: How to display Security Definitions, etc"
"You should be able to display your resource categories and groups
defined to OCF if this is how it was setup. In OCF set to the system
dictionary try doing a 'dis all res cat'. Then you can display the
individual resource category. You can also do a 'dis all groups' but
like I said there are many ways to set this up, hope this helps.
Steve Harmeson