VOC Set up in windows

hi all,

How to setup a db.account in jbase on NT.
how to set up the basic voc setup such that i can use q pointers.
what are the voc entries needed to be created
right now in NT i am not able to use QPTRS to list a BP.

Hi Girish,

Its very simple.

Check whether SYSTEM file and its dictionary exists in C:JBASE40src folder.

If not exists login to the src folder in jBASE prompt and create a j4 file as follows.

jsh mkandan c:jbase40src -->CREATE-FILE SYSTEM TYPE=J4 4 5

Ok SYSTEM file got created. Now go into your bnk.run account and check whether is there any VOC pointing to DB.ACCOUNT.

If not exists create a VOC as below.

File VOC , Record 'DB.ACCOUNT'
Command->
001 F
002 C:JBASE40srcSYSTEM
003 C:JBASE40srcSYSTEM]D

Try to query DB.ACCOUNT as below

LIST DB.ACCOUNT

If no error comes then we ensure that the DB.ACCOUNT is got created perfect in your bnk.run environment. The creation of VOC should be done in all your bnk.run environments.

Once you fix this and let me know.
_________________
M A L A I

hi malai,

by default after installation of jbase file it is creating only SYSTEM]D file.
Even in jbase doc they are mentioning only about MD]D
and not about creating MD.

i dont know database is courppted or not i am getting the following error.

jsh g13dev C:JBASE40src -->CREATE-FILE SYSTEM TYPE=J4 4 5
[ 413 ] File name DICT SYSTEM already exists

jsh g13dev ~ -->LIST DB.ACCOUNT
No file name could be found for your query

hope each account will have an entry in SYSTEM file.
so if i create a file J4 file will i be overriding jbase dir structure.

Entha Girishey.

I think jBASE wont create the SYSTEM file.
It doesnt mean that jBASE got corrupted.
Delete the exisitng dictionary and proceed, no issues.

If SYSTEM file itself not there then where will you have entry for all environments.

If you create again it wont override jBASE dir structure.

Proceed with DILL
_________________
M A L A I

hi malai,
even if i delete SYSTEM]D
and try to create a j4 file SYSTEM as given below it is throwing error.

jsh g13dev C:JBASE40src -->CREATE-FILE SYSTEM J4 4 5
** Error [ JEDI_FILEOP_FORMAT_ERROR ] **
File operation command format error

so i think while installing jbase these files were not created .

To my knowlege jBASE wont create this SYSTEM file.

There is a problem in your CREATE-FILE statement.

You missed out the TYPE.

CREATE-FILE SYSTEM TYPE=J4 4 5
_________________
M A L A I

you can create the file without using type....
CREATE.FILE ABC 4 13

this will create file ABC with type j4 and modulo 13
_________________
takoor

Hi all,

Am a new member to this group, joined jus now.

I was seeing the previous messages posted, and found this Forum very useful.

Hi Girish,

If you still having the problem of creating the SYSTEM file, please try the below steps. I faced a similar problem some weeks ago and this solution solved my problem.

1)Remove the SYSTEM and SYSTEM]D (physically) from the C:jbase44.1srcSYSTEM.

2)Create SYSTEM as a file as shown below,
jsh ~ -->CREATE-FILE C:jbase44.1srcSYSTEM 1 19
[ 417 ] File C:jbase44.1srcSYSTEM]D created , type = J4
[ 417 ] File C:jbase44.1srcSYSTEM created , type = J4

3)jsh -- > JED VOC SYSTEM
01Q
02SYSTEM

4)Check the jstat ?v SYSTEM

jsh ~ -->jstat -v SYSTEM
File C:jbase44.1srcSYSTEM
Type=J4 , Hash method = 3
Created at Wed Dec 14 07:38:22 2005
Groups = 19 , Frame size = 4096 bytes , Secondary Record Size = 8192 bytes
Restore re-size parameters : (none)
File size = 81920 bytes , Inode = 25888 , Device = Id 24140
Last Accessed Wed Dec 14 08:06:31 2005 , Last Modified Wed Dec 14 08:06:31 2005
Backup = YES , Log = YES , Rollback = YES , Network = NO


Record Count = 1 , Record Bytes = 90
Bytes/Record = 90 , Bytes/Group = 4
Primary file space: Total Frames = 19 , Total Bytes = 90
Secondary file space: Total Frames = 0 , Total Bytes = 0

Please excuse me if u have already solved this problem
_________________
Regards,
Madhan Kumar. M

Hi Madhan,

Thanks for your info.

Be an active member on this forum.

Thanks Again
Malai

Hi All,

While Creating a file using the CREATE-FILE, if the system returns an error saying the dict already exists, you can create just the data part as below.

jsh t24 ~ -->CREATE-FILE TEST.FILE TYPE=J4 4 5
[ 413 ] File name DICT TEST.FILE already exists
jsh t24 ~ -->CREATE-FILE DATA TEST.FILE TYPE=J4 4 5
[ 417 ] File TEST.FILE created , type = J4
jsh t24 ~ -->

Similarly you can also create just the dict for a already existing data file.

I know that the above is not in context to the actual post but since it has to do with create files, I have posted the same.

Thanks
Ameet