Datastage Enterprise Read Hashed File
Hello,While searching for ways to monitor Windows Update on client machines, I ran across information indicating that Windows stores most of its Windows Update information inside of the Datastore.edb file found inside C:WindowsSoftwareDistributionDatastore.1.) Does anyone know of a Microsoft-sanctioned way to access this database? The information I am looking for does not seem to be available with the Windows Update Agent API (unless I somehow missed it). I would like to know what folder under SoftwareDistributionDownloadspecific updates are downloaded to. I would also like to know what executables will be launched to start the installation.2.) Does anyone know of a generic EDB database viewer? I was unable to find one that could read the Datastore.edb file.3.) Does anyone know of source code for accessing/querying an EDB database?Thank you for any help you can provide. I was hoping to find a way to associate individual files in C:WindowsSoftwareDistributionDownload with their associated updates.
DataStage is available in several versions, including Enterprise Edition, Server Edition and MVS Edition. Actives stages, such as the Transformer and Aggregator, perform processing tasks, while passive stages, such as the Sequential File stage and Hashed File stage, are reading or writing data sources and provide services to the active stages. IBM Information Sever architecture; Data Stage in IBM Information server architecture. Create a job to read data from multiple files by using file pattern; Saving and load table. Dynamic RDBMS; Oracle Enterprise; ODBC Enterprise; ODBC connector; Stored Procedure. Hash, Entire, Same, Modules, Range, DB2, Auto). There are two types of hash files in DataStage i.e. Static Hash File and Dynamic Hash File. The static hash file is used when limited amount of data is to be loaded in the target database. The dynamic hash file is used when we don’t know the amount of data from the source file.
That would allow me to know what binary files were actually responsible for each update.Ahhh. Well, that can actually be done without the need to access the WUAgent datastore!First thing I'll mention is that the files in the Datastore folder should be automatically maintained by the WUAgent. They should be purged 10 days after successful installation. If all downloaded updates have been installed to the machine, you can safelypurge anything older than 10 days.The filenames in the folder that are 40-characters long, are the SHA-1 hashed filename of the update file itself, and they can be correlated with the list of filenames for an update available from the Updates View, on the File Information menu option ofthe context menu for the update. Given that the fundamental question seems to be about 'monitoring Windows Update on client machines', perhaps the proper starting point is to better describe what you mean by 'monitoring Windows Update', and what your ultimate objectives might be.Since you've posted in a.WSUS. forum, I'll assume you're aware of WSUS as a product, which is how one would typically 'monitor Windows Update' in an organizational environment.To your questions:1.
Datastage Enterprise Read Hashed File Free
There is no Microsoft-sanctioned access to that database. The database is used internally by the WUAgent to support the activities of the WUAgent. However, it should be noted that the database is a standard JET database, so just about any JET-designedtools should be workable. Previous admins have had some success using the Exchange DB Repair tools on the DATASTORE.EDB.2.
Trp of indian serials this week 2019 barc. BARC (TRP) Ratings Of Indian TV Shows June 20191.
A 'generic' EDB database viewer? I'd start with Microsoft Access.3. Source code??? If you mean the database schema.
The schema is not publicly documented.Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSAPrincipal/CTO, Onsite Technology Solutions, Houston, Texas Microsoft MVP - Software Distribution (2005-2011)My MVP Profile: Blog: http://onsitechsolutions.spaces.live.com. I was hoping to find a way to associate individual files in C:WindowsSoftwareDistributionDownload with their associated updates. That would allow me to know what binary files were actually responsible for each update.Ahhh. Well, that can actually be done without the need to access the WUAgent datastore!First thing I'll mention is that the files in the Datastore folder should be automatically maintained by the WUAgent. They should be purged 10 days after successful installation. If all downloaded updates have been installed to the machine, you can safelypurge anything older than 10 days.The filenames in the folder that are 40-characters long, are the SHA-1 hashed filename of the update file itself, and they can be correlated with the list of filenames for an update available from the Updates View, on the File Information menu option ofthe context menu for the update. Hello Mercury529,In the C:WindowsSoftwareDistributionDownload directory, you can find 40-char length files name that correspond to the 40 final chars of.For a complete cleaning (clearing also the whole update history):.
net stop wuauserv. net stop bits. delete all files inside the C:WindowsSoftwareDistributionDownload directory. delete the DataStore.edb into C:WindowsSoftwareDistributionDataStore.
net start bits. net start wuauservand, take a look to my free utility to manage your windows updates:Regards,gigirex. Hello,While searching for ways to monitor Windows Update on client machines, I ran across information indicating that Windows stores most of its Windows Update information inside of the Datastore.edb file found inside C:WindowsSoftwareDistributionDatastore.1.) Does anyone know of a Microsoft-sanctioned way to access this database? The information I am looking for does not seem to be available with the Windows Update Agent API (unless I somehow missed it). I would like to know what folder under SoftwareDistributionDownloadspecific updates are downloaded to. I would also like to know what executables will be launched to start the installation.2.) Does anyone know of a generic EDB database viewer? I was unable to find one that could read the Datastore.edb file.3.) Does anyone know of source code for accessing/querying an EDB database?Thank you for any help you can provide.Hello,I was searching for a way to maybe import the datastore.edb file to an SQL Server database when I came across your question.
There is a non-Microsoft sanctioned utilitythat works on Windows 7 x64. The utility will allow you to export to HTML file.
Dear sir,As stated above my problem is with the routine Lookup which among others is written by Ascential.I have a job that copies data from a table into a hash file. Now I need to read the contents of this hash file (a particular field) by supplying the key. The value retrieved has to be passed to a job as a parameter. Inspite of the hash file existing clearly, the Lookup routine refuses to acknowledge its presence. I keep getting the message '.Table Not Found.' I believe this kind of usage requires some kind of pointer creation in Datastage Administrator which links the name of the hash file to the project.
However I do not know how carry out this configuration.I would be most obliged if I could get some help in this regard.SincerelyS. I am attaching a DSX file containing the routine called Lookup incase it helps towards finding a solution.
bYou can try these instructions to add such a pointer to the VOC./bTelnet to the DataStage server, change to the DSHOME directory (where the dsenv file is), run the dsenv file, then start the DataStage command line.cd `cat /.dshome`./dsenvbin/dssh/codeNow you should have a prompt. Log to your project. Case matters.LOGTO Project1/codeCreate VOC entry for the hash file. Case matters. In this example, 'BrowserLu' is my hash file name. My comments are out to the side of each line.ED VOC BrowserLuNew record.-: I I = insert0001= F F = file type0002= /dwhp/data/wba/hash/BrowserLu path and filename of hash file0003= /dwhp/data/wba/hash/DBrowserLu path and filename of dictionary0004= hit Enter for a blank lineBottom at line 3.-: FI FI = file (to save the entry)'BrowserLu' filed in file 'VOC'./codeYou can enter 'Q' to quit the command line.If you need to delete such a pointer but not delete the hash file itself, you can use the DELETE VOC command.DELETE VOC BrowserLu/codeEric. bYou can try these instructions to add such a pointer to the VOC./bTelnet to the DataStage server, change to the DSHOME directory (where the dsenv file is), run the dsenv file, then start the DataStage command line.cd `cat /.dshome`./dsenvbin/dssh/codeNow you should have a prompt.
Log to your project. Case matters.LOGTO Project1/codeCreate VOC entry for the hash file. Case matters.
Hash File In Datastage
In this example, 'BrowserLu' is my hash file name. My comments are out to the side of each line.ED VOC BrowserLuNew record.-: I I = insert0001= F F = file type0002= /dwhp/data/wba/hash/BrowserLu path and filename of hash file0003= /dwhp/data/wba/hash/DBrowserLu path and filename of dictionary0004= hit Enter for a blank lineBottom at line 3.-: FI FI = file (to save the entry)'BrowserLu' filed in file 'VOC'./codeYou can enter 'Q' to quit the command line.If you need to delete such a pointer but not delete the hash file itself, you can use the DELETE VOC command.DELETE VOC BrowserLu/codeEric.
This last one is what worked for me.SETFILE.Thanks a lot to all of you for your help. Although my problem is solved I'm not sure I understod all your solutions especially those of you who said that this routine in its original form isn't meant to work with directory based hash files. This is because in all the other projects where it is used the hash files are directory based and the routine exists as attached yesterday.
Thus no modification of the 'Open' function to 'Openpath' etc.What I now understand is the SETFILE command takes care of this. I hope I am not mistaken. This last one is what worked for me.SETFILE.Thanks a lot to all of you for your help. Although my problem is solved I'm not sure I understod all your solutions especially those of you who said that this routine in its original form isn't meant to work with directory based hash files. This is because in all the other projects where it is used the hash files are directory based and the routine exists as attached yesterday. Thus no modification of the 'Open' function to 'Openpath' etc.What I now understand is the SETFILE command takes care of this. I hope I am not mistaken.
My hash files are created using a normal Datastage job wherein data is extracted from (in my case) an Oracle stage and routed to a directory hash file where the path is specified by a parameter. (in my case /datastagetemp1pp/devautres/hash/)Now I find that the dictionary file is very much present in this directory i.e.
As I see, a subdirectory with the name of the hash file (e.g. DIO) is created and thus the files DATA.30 and OVER.30 are stored within this subdirectory while the dictionary file DDIO is stored in the parent directory /datastagetemp1pp/devautres/hash/. On the advice of Ascential technical support, when I ran the SETFILE command I supplied the hash file pathname as the directory containing the two.30 files and thus the subfolder.
Its therefore obvious that in this subdirectory the dictionary file wasn't found since the same is stored 1 level up.Is this a mistake? Should I supply the location name as the parent folder and not the subdirectory? My hash files are created using a normal Datastage job wherein data is extracted from (in my case) an Oracle stage and routed to a directory hash file where the path is specified by a parameter. (in my case /datastagetemp1pp/devautres/hash/)Now I find that the dictionary file is very much present in this directory i.e. As I see, a subdirectory with the name of the hash file (e.g. DIO) is created and thus the files DATA.30 and OVER.30 are stored within this subdirectory while the dictionary file DDIO is stored in the parent directory /datastagetemp1pp/devautres/hash/. On the advice of Ascential technical support, when I ran the SETFILE command I supplied the hash file pathname as the directory containing the two.30 files and thus the subfolder.
Its therefore obvious that in this subdirectory the dictionary file wasn't found since the same is stored 1 level up.Is this a mistake? Should I supply the location name as the parent folder and not the subdirectory? On the advice of Ascential technical support, when I ran the SETFILE command I supplied the hash file pathname as the directory containing the two.30 files and thus the subfolder. Its therefore obvious that in this subdirectory the dictionary file wasn't found since the same is stored 1 level up. Is this a mistake? Should I supply the location name as the parent folder and not the subdirectory?No, it's not a mistake and their instructions are correct. The SETFILE command is perfectly aware of where the dictionary file lives, so that is not the issue.Suggest you recontact Support and see if they can explain the behaviour.
Anything 'unusual' about the D file? Permissions / ownership different, perhaps?-craig.
On the advice of Ascential technical support, when I ran the SETFILE command I supplied the hash file pathname as the directory containing the two.30 files and thus the subfolder. Its therefore obvious that in this subdirectory the dictionary file wasn't found since the same is stored 1 level up. Is this a mistake? Should I supply the location name as the parent folder and not the subdirectory?No, it's not a mistake and their instructions are correct.
The SETFILE command is perfectly aware of where the dictionary file lives, so that is not the issue.Suggest you recontact Support and see if they can explain the behaviour. Anything 'unusual' about the D file? Permissions / ownership different, perhaps?-craig. However one piece of information I asked remains unanswered. Is there any online resourse where I can get a list of commands that are executed in Datastage Administrator on a particular project through the 'Command' window?For example:SETFILE: Create a pointerDELETE VOC: To delete an existing pointeretc.As of now i want to see how many hash file pointers are created for a project.Cheers Contacted Datastage support and it appears that the pathname supplied to SETFILE shouldn't contain a slash at the end which was the reason for my error message regarding the dictionary file. Solved n sorted.
Thanks everyone once again. However one piece of information I asked remains unanswered. Is there any online resourse where I can get a list of commands that are executed in Datastage Administrator on a particular project through the 'Command' window?For example:SETFILE: Create a pointerDELETE VOC: To delete an existing pointeretc.As of now i want to see how many hash file pointers are created for a project.Cheers Contacted Datastage support and it appears that the pathname supplied to SETFILE shouldn't contain a slash at the end which was the reason for my error message regarding the dictionary file. Solved n sorted. Thanks everyone once again. However one piece of information I asked remains unanswered. Is there any online resourse where I can get a list of commands that are executed in Datastage Administrator on a particular project through the 'Command' window?For example:SETFILE: Create a pointerDELETE VOC: To delete an existing pointeretc.As of now i want to see how many hash file pointers are created for a project.Cheers Contacted Datastage support and it appears that the pathname supplied to SETFILE shouldn't contain a slash at the end which was the reason for my error message regarding the dictionary file.
Solved n sorted. Thanks everyone once again.