Copy VOC entries of Hashed files

mavrick21 · Post by **mavrick21** » Fri Oct 26, 2012 2:06 pm

Hello Gurus,

We're migrating our jobs from one server to another - we're exporting/importing jobs & sequences; we're copying over the Hashed files.

Since all the Hashed files have an entry in VOC is there a way to export those entries into the new VOC? Any easier solution to create the VOC entries?

Thank you
-Mav

chulett · Post by **chulett** » Fri Oct 26, 2012 3:46 pm

Just to double-check - these are "account-based" hashed files that live in the Project, yes? Out of curiousity, how many are we talking about?

mavrick21 · Post by **mavrick21** » Fri Oct 26, 2012 3:50 pm

Yes Craig - these are "account-based" Hashed files that live in the Project. Between 350 to 500.

chulett · Post by **chulett** » Fri Oct 26, 2012 4:20 pm

I've never had to deal with that many as we kept as few as possible in the Projects, so I've handled them manually. And that meant validating the jobs that create them, so they create an empty hashed file and the VOC record and then copying over the Type30 directory contents from the old server / system.

Ray or Arnd may have a more... scripted... or automated approach in their bag of tricks. [crosses fingers]

ray.wurlod · Post by **ray.wurlod** » Sat Oct 27, 2012 9:02 am

Use the format.conv (also known as fnuxi) or uvbackup command to export the hashed files; this will also move their VOC entries.

When restoring, use format.conv or fnuxi or uvrestore respectively.

The format.conv and fnuxi commands have -export and -import options.

You can find details for all of these commands in UniVerse documentation.

chulett · Post by **chulett** » Sat Oct 27, 2012 9:07 am

Ah yes, uvbackup and uvrestore, forgot about those.

mavrick21 · Post by **mavrick21** » Sat Oct 27, 2012 9:09 am

I'll give that a try. Thanks Ray & Craig

mavrick21 · Post by **mavrick21** » Mon Oct 29, 2012 4:28 pm

Here is what I tried at UNIX prompt and I got an error. Please advise.

Code: Select all

format.conv -export -name zzz /path/mav121
Processing '/path/mav121'.
Exporting DDL from sica of table '/path/mav121'.
'/path/mav121' is not an SQL table, file was not modified.

mav121 directory contains DATA.30, OVER.30 and .Type30. I also see D_mav121 in parent directory and "SELECT * FROM mav121" in UV returns result.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Oct 29, 2012 9:30 pm

You can not use this technique with a hashed file except one that has a SICA (security and integrity constraints area), which means that you the hashed file was created with a UniVerse stage as a UniVerse/SQL table.

That's why I referred you to the documentation, so you could be aware of the restrictions on the various commands.

mavrick21 · Post by **mavrick21** » Tue Oct 30, 2012 6:37 am

I'll read up on the documentation for uvbackup. Hopefully I'll be able to export selected Hashed files using this command.

Thanks Ray.

mavrick21 · Post by **mavrick21** » Tue Oct 30, 2012 8:38 am

I tried uvbackup and got the below error. I put the Hashed file path "/path/mav121" in file "/home/dsadm/zzz" and tried backing up just one Hashed file.

Error:

Code: Select all

uvbackup -cmdfil /home/dsadm/zzz
*** glibc detected *** uvbackup: free(): invalid pointer: 0x08348fe0 ***
======= Backtrace: =========
/lib/libc.so.6[0x4506c5]
/lib/libc.so.6(cfree+0x59)[0x450b09]
uvbackup[0x82129d3]
uvbackup[0x8248424]
uvbackup[0x821babd]
uvbackup[0x805ae9a]
uvbackup[0x8061ece]
/lib/libc.so.6(__libc_start_main+0xdc)[0x3fce9c]
uvbackup(sinh+0x41)[0x804b8b9]
======= Memory map: ========
00145000-00146000 r-xp 00000000 08:11 3407886    /ps/dsadm/Ascential/DataStage/DSEngine/uvdlls/libUtilWSClient.so
00146000-00147000 rw-p 00000000 08:11 3407886    /ps/dsadm/Ascential/DataStage/DSEngine/uvdlls/libUtilWSClient.so
003c8000-003e3000 r-xp 00000000 fd:00 2588686    /lib/ld-2.5.so
003e3000-003e4000 r--p 0001a000 fd:00 2588686    /lib/ld-2.5.so
003e4000-003e5000 rw-p 0001b000 fd:00 2588686    /lib/ld-2.5.so
003e7000-0053a000 r-xp 00000000 fd:00 2588693    /lib/libc-2.5.so
0053a000-0053c000 r--p 00153000 fd:00 2588693    /lib/libc-2.5.so
0053c000-0053d000 rw-p 00155000 fd:00 2588693    /lib/libc-2.5.so
0053d000-00540000 rw-p 0053d000 00:00 0
00542000-00545000 r-xp 00000000 fd:00 2588697    /lib/libdl-2.5.so
00545000-00546000 r--p 00002000 fd:00 2588697    /lib/libdl-2.5.so
00546000-00547000 rw-p 00003000 fd:00 2588697    /lib/libdl-2.5.so
00549000-00570000 r-xp 00000000 fd:00 2588699    /lib/libm-2.5.so
00570000-00571000 r--p 00026000 fd:00 2588699    /lib/libm-2.5.so
00571000-00572000 rw-p 00027000 fd:00 2588699    /lib/libm-2.5.so
006be000-006c7000 r-xp 00000000 fd:00 2588966    /lib/libcrypt-2.5.so
006c7000-006c8000 r--p 00008000 fd:00 2588966    /lib/libcrypt-2.5.so
006c8000-006c9000 rw-p 00009000 fd:00 2588966    /lib/libcrypt-2.5.so
006c9000-006f0000 rw-p 006c9000 00:00 0
00816000-00821000 r-xp 00000000 fd:00 2588706    /lib/libgcc_s-4.1.2-20080825.so.1
00821000-00822000 rw-p 0000a000 fd:00 2588706    /lib/libgcc_s-4.1.2-20080825.so.1
00b62000-00b6c000 r-xp 00000000 fd:00 2588726    /lib/libnss_files-2.5.so
00b6c000-00b6d000 r--p 00009000 fd:00 2588726    /lib/libnss_files-2.5.so
00b6d000-00b6e000 rw-p 0000a000 fd:00 2588726    /lib/libnss_files-2.5.so
00d00000-00d01000 r-xp 00d00000 00:00 0          [vdso]
08048000-08314000 r-xp 00000000 08:11 3407961    /ps/dsadm/Ascential/DataStage/DSEngine/bin/uvbackup
08314000-08349000 rw-p 002cb000 08:11 3407961    /ps/dsadm/Ascential/DataStage/DSEngine/bin/uvbackup
08349000-08374000 rw-p 08349000 00:00 0
0933f000-09360000 rw-p 0933f000 00:00 0          [heap]
b7b5d000-b7f5c000 rw-s 00000000 00:09 69992458   /SYSVade0bac0 (deleted)
b7f5c000-b7f5e000 rw-p b7f5c000 00:00 0
b7f68000-b7f6b000 rw-p b7f68000 00:00 0
bddb2000-beeac000 rw-s 00000000 00:09 3670021    /SYSVadec7521 (deleted)
beeac000-beeaf000 rw-s 00000000 00:09 70057990   /SYSVadeb000c (deleted)
bf0b0000-bf18e000 r--s 00000000 00:09 3735559    /SYSVadee7521 (deleted)
bf894000-bf8a9000 rw-p bffe9000 00:00 0          [stack]
Aborted