This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 22%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
I am trying to fetch data from on premise DB2 using Azure Data Factory through copy activity but getting an error while doing the same. I have created Linked Service and connection is successful but while listing tables in Dataset or previewing data I am getting this below error:
"The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805,"
I have referred the MS documentation https://learn.microsoft.com/en-us/azure/data-factory/connector-db2?tabs=data-factory#linked-service-properties in which they are telling that collection package should be filled where we want to query. Currently package is getting created by default in Collection which is based on the username.
So, What should be the location of package so that I can query data and preview data in DB2. Furthermore, what value(database name, repository name) should I specify in CollectionPackage of Linked Service???
I am attaching The snippet for this for reference.
Hi @Himanshu Devrani - Just checking if below answers helps. If yes please consider marking them as Accepted Answer. Accepted answers helps community as well.
Can you try with keeping package collection value as NULLID ?
DB2 packages are by default created under the NULLID collection.
Hi @Himanshu Devrani ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
Hi @Himanshu Devrani - Just check if above helps? If yes, then kindly consider marking it as Accepted Answer. Thank you.
Hi @Himanshu Devrani ,
Thank you for posting query in Microsoft Q&A Platform.
For "packageCollection", Specify where needed packages are auto creating by service when querying database. If we skip it then service uses {username} as the default value.
If you are not sure where packages are auto created then checking with DB2 admin may helpful.
database name is your DB2 database name.
When you say repository name, what you mean by that? Kindly elaborate more on that?
Below is the format of connection string that can be used for DB2 linked service.
server=<server:port>;database=<database>;authenticationType=Basic;username=<username>;password=<password>;packageCollection=<packagecollection>;certificateCommonName=<certname>;
Hope this will help. Please let us know if any further queries. Thank you.
--------------------
Please consider hitting Accept Answer. Accepted answers helps community as well.
Hi @ShaikMaheer-MSFT ,
Thank you for your reply.
When I say repository name, I am asking the location where ADF will create packages so that we can execute the query from copy activity in DB2.
So for that ,What should I specify in Collection Package property of Linked Service ?? A DB Name or what exact location or string or value I need to specify in that property so that I can execute query in copy activity for copying data from DB2 tables .
I have referred MS documentation and they are suggesting to specify collection package property so that is my question what should I provide so that I can execute copy activity with a query .